怎么查找Oracle库中性能最差的SQL?
SELECT *
FROM (SELECT PARSING_USER_ID,
EXECUTIONS,
ELAPSED_TIME,
DISK_READS,
FIRST_LOAD_TIME,
RUNTIME_MEM,
CPU_TIME,
SHARABLE_MEM,
SQL_TEXT
FROM V$SQLAREA
WHERE FIRST_LOAD_TIME LIKE '%2020-03-03%'
ORDER BY FIRST_LOAD_TIME DESC)
WHERE ROWNUM <= 10 ;