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

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: