Thursday, January 1, 2009

How to find the most frequently executed SQL?

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

No comments:

Post a Comment