查询oracle正在运行效率最慢的前十条SQL:
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