11.2.0.3
library cache lock/cursor: pin S wait on X with parallel partition stats gathering
8441239
11.2.0.1
Library cache lock waits if long running TRUNCATE in progress
8348464
11.1.0.7.2, 11.2.0.1
CREATE SYNONYM and CREATE PACKAGE may incorrectly invalidate objects
7234778
11.2.0.1
Unnecessary "cursor: pin S wait on X" waits
5485914
10.2.0.4
Mutex self deadlock on explain / trace of remote mapped SQL
6143420
10.2.0.5, 11.1.0.6
Deadlock involving "ROW CACHE LOCK" on dc_users AND "CURSOR: PIN S WAIT ON X"
6011045
10.2.0.5.5
DBMS_STATS causes deadlock between 'cursor: pin S wait on X' and 'library cache lock'
7462072
10.2.0.4.3, 10.2.0.5
Unnecessary "cursor: pin S wait on X" waits
5983020
10.2.0.4
MMON deadlock with user session executing ALTER USER
7226463
10.2.0.5
EXECUTE IMMEDIATE no releasing mutex or library cache pin
+
5907779
10.2.0.4
Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)