查看oracle sql资源占用过剩的sql

2012-07-18

查看oracle sql资源占用过多的sqlSELECT ROWNUM top, t.*FROM (SELECTx.CPU_TIME/x.executions per_cpu, x

查看oracle sql资源占用过多的sql

SELECT ROWNUM top, t.*
FROM (SELECT   x.CPU_TIME/x.executions per_cpu, x.hash_value, x.sql_text
            FROM v$sqlarea x
           WHERE x.executions>0
             AND x.parsing_user_id <>0
        ORDER BY x.CPU_TIME/x.executions DESC) t
WHERE ROWNUM < 21