通过ORACLE提供的底层SQL来查找性能最差的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 ; --查找前十条性能差的sql
通过ORACLE提供的底层SQL来查找性能最差的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 ; --查找前十条性能差的sql
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
