Advertisement
Guest User

Untitled

a guest
Oct 13th, 2019
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. To find the top SQL statements that have caused most block buffer reads:
  2.  
  3. Select buffer_gets, sql_text
  4. from v$sqlarea
  5. where buffer_gets > 10000
  6. order by buffer_gets desc;
  7.  
  8.  
  9. To find the most frequently executed SQL:
  10.  
  11. Select executions, buffer_gets, sql_text
  12. from v$sqlarea
  13. where executions > 10000
  14. order by executions desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement