|
1. 查看性能最差的前100sql
SELECT * FROM ( SELECT PARSING_USER_ID EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,sql_text
FROM v$sqlarea ORDER BY disk_reads DESC) WHERE ROWNUM<100 2.oracle 10g 查看某session的歷史執(zhí)行sql情況(sql采樣間隔1s)
oracle 10g 通過v$active_session_history查看某session(這里指定為190)的歷史執(zhí)行sql情況(sql采樣間隔1s) select s.SAMPLE_TIME, sq.SQL_TEXT, sq.DISK_READS, sq.BUFFER_GETS, sq.CPU_TIME, sq.ROWS_PROCESSED, --sq.SQL_FULLTEXT, sq.SQL_ID from v$sql sq, v$active_session_history s where s.SQL_ID = sq.SQL_ID and s.SESSION_ID = 190 order by s.SAMPLE_TIME desc; |
|
|
