Which caused the "library cache" latch?

From: Lou Fangxin <anysql_at_gmail.com>
Date: Thu, 22 Sep 2005 11:23:50 +0800
Message-ID: <ea5907d305092120234b673022@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 21 2005 - 22:25:58 CDT