Oracle query usage frequency and disk consumption require cache size

SELECT *   from(SELECTSql_text, sql_id, Cpu_time fromV$sqlORDER  byCpu_timeDESC) WHERERownum<= Ten ORDER  byRownumASC;SELECT *   from(SELECTSql_text, sql_id, Cpu_time fromV$sqlareaORDER  byCpu_timeDESC) WHERERownum<= Ten ORDERByrownumASC;

These 2 statements effect basically the same, one from the V$sql view query from the V$sqlarea view.

列出使用频率最高的5个查询：

SELECT sql_text, executions    from (SELECT  sql_text,               executions,               over (ORDERbyDESC  ) Exec_rank          fromWHERE<=5;

消耗磁盘读取最多的sql top5： 

SELECT disk_reads, Sql_text    from (SELECT  sql_text,               disk_reads,               over (ORDERbyDESC  ) Disk_reads_rank          fromWHERE<=5;

找出需要大量缓冲读取（逻辑读）操作的查询：

SELECT buffer_gets, Sql_text    from (SELECT  sql_text,               buffer_gets,               over (ORDERbyDESC  ) Buffer_gets_rank          fromWHERE<=5  ;

Oracle query usage frequency and disk consumption require cache size