查询Oracle使用CPU最多的前10条语句:
SQL> select * from (
select trunc(ts.CPU_TIME/ts.EXECUTIONS) "cpu_time/exes",
ts.EXECUTIONS exec_count,ts.SQL_TEXT
from v$sql ts where ts.EXECUTIONS > 0 order by 1 desc )
where rownum <= 10
and exists (select instr(BANNER,'9i') from v$version WHERE ROWNUM<=1);