查看性能最差的前100sql

SELECT * FROM ( SELECT PARSING_USER_ID EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,sql_text 
                FROM v$sqlarea 
                ORDER BY disk_reads DESC) 
   WHERE ROWNUM<100

 

评论

1 楼 jiiming 2014-04-01  

v$sqlarea这货还有很多作用，比如查看CPU耗时，执行时间等

/**CPU耗时版 :wink: */
SELECT *
  FROM (SELECT *
          FROM v$sqlarea
         ORDER BY cpu_time DESC)
 WHERE ROWNUM < 100