RE: Global Cache Converts & V$SYSSTAT "Time"

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: <cmarquez@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Oct 2005 15:17:22 -0700

is this one of your top 5 wait events ?

        col "Average Time" format 999.999
        SELECT V$SYSSTAT.VALUE*10 / (select value from v$sysstat where
name = 'global cache gets')  "Average Time"
        FROM V$SYSSTAT
        WHERE V$SYSSTAT.NAME = 'global cache get time'
        /
        Average Time
        ------------
              19.883
        

--
http://www.freelists.org/webpage/oracle-l

Other related posts: