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
查看oracle sql资源占用过多的sql
最新推荐文章于 2024-05-26 07:34:53 发布