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.
