Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Global Cache Converts & V$SYSSTAT "Time"

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

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Thu, 20 Oct 2005 15:17:22 -0700
Message-ID: <B9782AD410794F4687F2B5B4A6FF3501021D4E2B@ex1.ms.polyserve.com>


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
Received on Thu Oct 20 2005 - 17:19:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US