Sriram Sanka

Query for Top 10 by Executions:

Posted by Sriram Sanka on September 13, 2022

set linesize 100
set pagesize 100
SELECT * FROM
(SELECT substr(sql_text,1,40) sql,
        executions, rows_processed, rows_processed/executions "Rows/Exec",
        hash_value,address
   FROM V$SQLAREA
  WHERE executions > 100
 ORDER BY executions DESC)
WHERE rownum  <=10
;

This entry was posted on September 13, 2022 at 12:09 am and is filed under Performance, sql. Tagged: oracle, sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.