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

Home -> Community -> Mailing Lists -> Oracle-L -> 10Gr2 and Library Cache Lock Waits

10Gr2 and Library Cache Lock Waits

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Sun, 4 Feb 2007 02:04:19 -0800
Message-ID: <7F24308CD176594B8F14969D10C02C6C011B1335@exch-mail2.win.slac.stanford.edu>


Is there anything in 10GR2 which makes it more prone to library cache lock waits. This would be something peculiar to 10.2 and not 10.1. The locks occur when one process creates a table, drops the original, renames the new back to the original name while another process creates or replaces any associated views which have gone invalid. Not the way, I would have written the system. However, it's worked for over a decade. Anyhow, in 10Gr2 timing issues result in in intermittent library cache lock waits which were not seen before.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 04 2007 - 04:04:19 CST

Original text of this message

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