Abnormally Long Waiting Time On "library cache lock" and 'cursor: pin S wait on X' In RAC Environment
(Doc ID 2518905.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.
Symptoms
- In RAC environment, a lot of sessions hang on "library cache lock" and 'cursor: pin S wait on X' with very long waiting time, and "library cache lock" seems not to honour the timeout:
xxxxx_dia0_17571_35.trc:
Chain 1:
-------------------------------------------------------------------------------
Oracle session identified by:
{
... ...
}
is waiting for 'cursor: pin S wait on X' with wait info:
{
p1: 'idn'=0x8e892a05
p2: 'value'=0x95d00000000
p3: 'where'=0x500000000
time in wait: 105 min 17 sec
timeout after: never
wait id: 31
blocking: 0 sessions
wait history:
... ...
}
and is blocked by
=> Oracle session identified by:
{
... ...
}
which is waiting for 'library cache lock' with wait info:
{
p1: 'handle address'=0x84bdb4130
p2: 'lock address'=0x846bd1498
p3: '100*mode+namespace'=0xa1ea00010002
time in wait: 105 min 54 sec
timeout after: never * <<<<<---------------
wait id: 32
blocking: 11 sessions
wait history:
... ...
}
Chain 1 Signature: 'library cache lock'<='cursor: pin S wait on X' - SQL tuning advisor task against a large SQL was ran for hours
Changes
SQL tuning advisor task against a large SQL was ran for hours.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |