Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Oct 20 2005 - 17:19:57 CDT
![]() |
![]() |