RE: Which caused the "library cache" latch?

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Thu, 22 Sep 2005 11:39:48 -0400
Message-ID: <A2C7821363A0544987988F6BCCE941B5060846@pegasus.lawaudit.com>

Lou, library cache latch is caused by solar flares which, in turn, cause significant magnetic activity. The best thing to

do is to backup your database to tape and put somewhere warm, to protect it from magnetic activity by the sun. Vicinity

of a heater or a radiator will do just fine,

Mladen Gogala

Ext. 121

From: Lou Fangxin [mailto:anysql_at_gmail.com] Sent: Wednesday, September 21, 2005 11:24 PM To: Oracle-L
Subject: Which caused the "library cache" latch?

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?

Can we have a talk about this?

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 22 2005 - 10:40:14 CDT