rem *************************************************************

rem * Name : trace.SQL

rem *

rem * Date: July 15 2001

rem * Purpose: Show cursors in shared pool with statistics

rem * Modify where condition to filter the statements you 

rem * want to show

rem *

rem * Downloaded from www.oradev.com

rem *************************************************************



set pages 100

select sql_text

, executions

, round((disk_reads+buffer_gets)/executions,2) average

, (disk_reads+buffer_gets) reads

, first_load_time

from v$sql

where  1=1

--and   UPPER(sql_text) like '%MTC%'

--and   UPPER(sql_text) not like '%DUAL%'

and   executions != 0

order by (disk_reads+buffer_gets)

;