RE: Global Cache Converts & V$SYSSTAT "Time"
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2005 18:24:05 -0400
>>is this one of your top 5 wait events ?
I have not run a statspack recently and regarding sessions I have been seeing
all day, "No".
Very few RAC related waits today if any, but I have seen them inexplicably in
the past.
Node2 for us is always idle, no db sessions....so RAC waits should be NULL or
minimal always...but that is not always the case.
Also, things (load, waits, etc.) were much less in general with node 2 instance
down for the past few days.
Chris Marquez
Oracle DBA
-----Original Message-----
From: Kevin Closson [mailto:kevinc@xxxxxxxxxxxxx]
Sent: Thu 10/20/2005 6:17 PM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: 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
Other related posts:
