Oracle查询sql执行时间
2018-07-19 本文已影响0人
是瑞瀛呀
select
DISK_READS,
FIRST_LOAD_TIME,
sql_text
from vsqlarea order by vsqlarea.FIRST_LOAD_TIME desc
;
SELECT * FROM (
SELECT PARSING_USER_ID
EXECUTIONS,
SORTS,
COMMAND_TYPE,
DISK_READS,
sql_text
FROM v$sqlarea
ORDER BY disk_reads DESC )
WHERE ROWNUM<10 ;