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

How to find SQL Query statistics 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 exact SQL, number of executions and information related to Disk I/O as shown below.

view sourceprint?
1select * from  v$sql;
2 
3select 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;

 
  


  
bl  br