Re: Library cache lock vs. pin

Paul:

Library cache locks are held on Library cache object handles whereas Library
cache pins held on data heaps.
Pins are held in shared mode to read data heap / to avoid modifications of
dependant objects.
Pins held in exclusive mode to mdify data heap.
Where as Library cache locks are held in exclusive mode to all parent and
child object handles and simultaneously held in shared mode for all
dependencies.

Thanks
-Harish Kalra



On 1/20/06, Paul Baumgartel <paul.baumgartel@xxxxxxxxx> 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
>
>

Other related posts: