Which caused the "library cache" latch?
- From: Lou Fangxin <anysql@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Sep 2005 11:23:50 +0800
Hi all:
The following is the change of v$latch in five seconds, I am not sure which
will cause the library cache latch? And the spin_gets of
cache_buffers_chains is always 0, so does it meas that cache buffers chains
latch wait will not consume much cpu?
-Get/S--Mis/S--Slp/S-IGet/S-IMis/s-SGet/S--Latch------------------------------(Top
Latch)-------
11K 437 3 0 0 434 library cache
4751 55 0 0 0 55 shared pool
74K 27 1 205 0 0 cache buffers chains
2262 25 0 0 0 25 row cache objects
5968 16 0 0 0 16 library cache pin
Can we have a talk about this?
--
Welcome, Fangxin.Lou from China
MYDUL, alternative to DUL !!!
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html
Other related posts:
