tl  tr
  Home | Tutorials | Articles | Videos | Products | Tools | Search
Interviews | Open Source | Tag Cloud | Follow Us | Bookmark | Contact   
 Articles > Database > How to find most frequently run SQL queries in Oracle

How to find most frequently run SQL queries in Oracle

Author: Venkata Sudhakar

Oracle exposes a view called v$sql which gives the performance statistics of the queries being run. We can find most frequently run SQL queries by sorting v$sql view on EXECUTIONS column.


 
  


  
bl  br