|
|
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.
1 | select * from v$sql order by EXECUTIONS desc; |
3 | select SQL_ID, SQL_FULLTEXT, EXECUTIONS, PARSE_CALLS, DISK_READS, BUFFER_GETS, CONCURRENCY_WAIT_TIME, USER_IO_WAIT_TIME, ROWS_PROCESSED, CPU_TIME, ELAPSED_TIME, PHYSICAL_READ_BYTES from v$sql order by EXECUTIONS desc; |
|
|
