SQL Script TOP Consistent Gets

Updated : 08-Jan-2002
Version : 1.0

Description

Script displays the top 10 consistent gets within the database - a good indicator which session is performing the most reads (p[hysical and logical)

Parameters

None

SQL Source

col program form a30 heading "Program"
col CPUMins form 99990 heading "CPU Mins"
col value form 999,999,999,999

spool topcpu.lst

select rownum as rank, a.*
from (
    SELECT v.sid, program, v.value 
    FROM v$statname s , v$sesstat v, v$session sess
   WHERE s.name = 'consistent gets'
     and sess.sid = v.sid
     and v.statistic#=s.statistic#
     and v.value>0
   ORDER BY v.value DESC) a
where rownum < 11
   ;

spool off

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal