Re: Library cache lock vs. pin

  • From: Ray Stell <stellr@xxxxxxxxxx>
  • To: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
  • Date: Thu, 19 Jan 2006 17:06:34 -0500

Oracle8i Internal Services for Waits, Latches, Locks, and Memory (Paperback)
by Steve Adams 
ISBN: 156592598X

Steve seems to indicate that these are layers (if I interpret him correctly), 
locks can be broken (if ddl modifies the object), but only if the object is 
not pinned, an pinning takes place during a compile, parse, or exec.  


On Thu, Jan 19, 2006 at 04:18:17PM -0500, Paul Baumgartel wrote:
> Can someone on the list explain succinctly the difference between a library
> cache lock and a library cache pin, and why both of these concurrency
> control mechanisms are necessary?
> 
> --
> Paul Baumgartel
> paul.baumgartel@xxxxxxxxxxxx

-- 
--
//www.freelists.org/webpage/oracle-l


Other related posts: