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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
