Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Question regarding v$latch
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
------------------------- --------- --------- --------------
messages 1655325 1 0 0 cache buffers chains 37394699 5 1059790 0 Checkpoint queue latch 510630 4 0 0 library cache 9517828 67 1956Received on Fri Jan 19 2001 - 12:53:52 CST
![]() |
![]() |