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

>>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_at_polyserve.com] Sent: Thu 10/20/2005 6:17 PM
To: Marquez, Chris; oracle-l_at_freelists.org 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
	

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