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

Home -> Community -> Mailing Lists -> Oracle-L -> Question regarding v$latch

Question regarding v$latch

From: Oak, Sameer <soak_at_ziptone.com>
Date: Fri, 19 Jan 2001 13:53:52 -0500
Message-Id: <10746.127180@fatcity.com>


When I run query on v$latch I get following result. The performance of database is degraded over time. Any help appreciated.
Also The buffer cache hit ratio is 97%

SUBSTR(NAME,1,25) GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES
------------------------- --------- --------- --------------



session allocation 953497 1 0 0
messages                    		1655325        1              0
0
cache buffers chains       	37394699      5        	1059790            0
Checkpoint queue latch       	510630         4              	0
0
library cache               		9517828        67           	1956
Received on Fri Jan 19 2001 - 12:53:52 CST

Original text of this message

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