This blog is created for the oracle DBA community who search a lot for valuable data on the internet.This is compilation of posts from various forums and groups.Oracle Database community is growing by the day and the necessity of such a blog will be felt very soon.
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