select * from
(
select
sql_id,
elapsed_time,
elapsed_time/executions avg_elapsed,
cpu_time/executions avg_cpu,
sql_text
from v$sql
order by avg_elapsed desc
)
where rownum < 11| SQL_ID | ELAPSED_TIME | AVG_ELAPSED | AVG_CPU | SQL_TEXT | c6mzj3hb4xyqq | 31555 | 31555 | 32009 | select * from ( select sql_id, elapsed_time, elapsed_time/executions avg_elapsed, cpu_time/executions avg_cpu, sql_text from v$sql order by avg_elapsed desc ) where rownum < 11 |
|---|