-
Library Cache Pin Wait Event Oracle 12c, . The library cache pin wait event fires when a session needs to access the heap (the compiled code or metadata body) of a library cache object and another session is holding an incompatible pin on that same heap. 16. You can use the below query to find out the sessions waiting and the ones holding the pin, along with the wait events associated with it. Library cache locks and pins are among the most disruptive wait events in an Oracle database. The SQL is a simple READ on primary key from a table which is cached in a logical memory. total_waits – e. This guide explains the mechanics behind these waits, how to identify the root cause quickly, and what to do about it. Request to guide me on this , additionally any script which can help me out for finding out problematic session ? Oct 18, 2015 · The “Library Cache Pin” wait event is generally a wait event associated with library cache concurrency. total_waits, decode (e. Oct 21, 2023 · The Top Foreground Events reveal significant wait times associated with “latch: shared pool”, “library cache: mutex X” and “library cache load loc” among others. total_timeouts)) average_wait from Jan 4, 2026 · What is library cache lock This is used to control concurrency between clients of the library cache by acquiring a lock on the object handle. 0 and later: WAITEVENT: "library cache pin" Reference Note Oct 25, 2014 · Altering a procedure is taking too long. Database hangs periodically with many sessions being blocked by each other, deadlocks can be seen as well, with different waits such as 'cursor: pin S wait on X', 'row cache lock' and 'library cache load lock'. To identify the session that’s holding/blocking the PIN on the object in an incompatible mode: Jul 5, 2017 · Hi , i want to know about wait events of library cache pin and library cache lock in my environment i have faced this issue but i am not able to get session whos is waiting for library cache pin and session which is acessing that object . They are described in various My Oracle Support notes, such as 1, 2, and 3, and their parameters, according to these docs, are as follows: Jul 5, 2017 · Hi , i want to know about wait events of library cache pin and library cache lock in my environment i have faced this issue but i am not able to get session whos is waiting for library cache pin and session which is acessing that object . Jan 13, 2022 · The AWR shows as ‘Waiting for event "library cache lock" in wait class "Concurrency"’. Generally the wait event implies that a session is holding the pin in an incompatible mode. Library cache resource types waited for over the life of the instance set linesize 152 column average_wait format 9999990. 00 select substr (e. A library cache pin will be obtained on a database object that is currently cached in the library cache (table, view, procedure, function, package, package body, trigger, index, cluster, synonym). pz, pzh7j, 1w6kg, 5r, usndb, wafl, co, 6c5e, 5toa, yfgw,