SQL Script TOP Consistent Gets

Updated: 08-Oct-2002
Version: 1.0

Description

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

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

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

spool topget.lst

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 
   ;

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links