OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed

How to find the most frequently executed SQL?

January 16th, 2006 By kirtandesai

Select executions, buffer_gets, sql_text
from v$sqlarea
where executions > 10000
order by executions desc;

I had to bump up the number of executions because the above statement returned a LOT of rows.

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question