查询数据库版本、常用表以及日访问频次的SQL（oracle 适用）

查询数据库版本、常用表以及日访问频次的SQL（oracle 适用）

SELECT (SELECT vv.banner
          FROM v$version vv
         WHERE 1 = 1
           AND vv.banner LIKE 'Oracle Database%') db_version, --数据库版本
       dtc.table_name, --常用表
       dtc.comments, --表描述
       round(vss.value / (trunc(SYSDATE) - do.created)) visit_frequency --访问频次
  FROM dba_tab_comments     dtc,
       dba_objects          do,
       v$segment_statistics vss
 WHERE 1 = 1
   AND dtc.owner = do.owner
   AND dtc.table_name = do.object_name
   AND dtc.table_type = do.object_type
   AND dtc.table_name = vss.object_name
   AND dtc.owner = vss.owner
   AND dtc.table_type = vss.object_type
   AND dtc.table_type = 'TABLE'
   AND vss.statistic_name = 'logical reads'
      --参数：用户
   AND vss.owner IN ('')
   and round(vss.value / (trunc(SYSDATE) - do.created)) > 100000 ---设定常用表的日访问次数
 ORDER BY round(vss.value / (trunc(SYSDATE) - do.created)) DESC