Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- To find the top SQL statements that have caused most block buffer reads:
- Select buffer_gets, sql_text
- from v$sqlarea
- where buffer_gets > 10000
- order by buffer_gets desc;
- To find the most frequently executed SQL:
- Select executions, buffer_gets, sql_text
- from v$sqlarea
- where executions > 10000
- order by executions desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement