This document was created manually to try and centralize the more common bugs relating to ORA-60 errors. It may not contain a
complete list of all bugs in all versions since newer bugs may need to be verified before inclusion. Please search My Oracle Support Portal with
neccessary keywords to get a list of all possible relevant documents.
This article is a consolidated effort to summarize top bugs reported specifically for the Dead lock error (This Note covers bugs reported versions
above 9.2.0.4) which have been fixed. It is directed towards Oracle Support Analysts and Oracle Customers to have an overview of various bugs logged
for the same error .
Details Bugs Fixed in Version 9.2.0.5 Note 2796282.8 Bug 2796282 False deadlock possible using shared servers Note 3001270.8 Bug 3001270 Deadlock between SMON and foreground process for dc_suers Note 3030298.8 Bug 3030298 OERI:2103 from concurrent 'drop tablespace including datafiles Note 3080929.8 Bug 3080929 ORA-4021 hang SMON self deadlock UNDO$ row cache lock Note 3093080.8 Bug 3093080 ALTER TABLE ENABLE TABLE LOCK can cause a deadlock Note 3271271.8 Bug 3271271 QMON can deadlock with job queue processes Note 3009268.8 Bug 3009268 Recovery of DEAD prepared TX may deadlock with SMON Note 2995746.8 Bug 2995746 Deadlock between session doing a GRANT Note 2918838.8 Bug 2918838 Undetected deadlock for dc_tablespace_quotas Bugs Fixed in Version 9.2.0.6 Note 3398485.8 Bug.3398485 Deadlock during on demand materialized view refresh (ORA-4020) Note 2615271.8 Bug.2615271 Deadlock from concurrent GRANT and logon Note 2014833.8 Bug.2014833 Deadlock possible from concurrent SELECT and TRUNCATE Note 3320292.8 Bug.3320292 Parallel recompilation hangs when recompiling type generated for pipeline function Note 3424721.8 Bug 3424721 deadlock ALTER INDEX REBUILD on partition with concurrent SQL Note.3166756.8 Bug.3166756 Self deadlock (ORA-60) / OERI possible on LOB index update Note 3605165.8 Bug.3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger Note 3717619.8 Bug.3717619 Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger Note 3562032.8 Bug.3562032 Cancelled ONLINE index rebuild can deadlock with DML session Note 3381218.8 Bug.3381218 Deadlock involving 'library cache lock' X mode request Bugs Fixed in Version 9.2.0.7 Note 3314850.8 Bug.3314850 Can deadlock with query rewrite sessions Note 3261205.8 Bug.3261205 Hang / OERI[kxttdropobj-1] on parallel direct load to temporary table Note 2883771.8 Bug.2883771 "WAITED TOO LONG FOR ROWCACHE ENQUEUE" when using Resource Manager in PLSQL Note 3896974.8 Bug.3896974 creating DIMENSIONs from schemas simultaneously Bugs Fixed in 9.2.0.8 10.1.0.5 Note 4114238.8 Bug 4114238 Deadlock between dc_users and dc_usernames row cache lock enabling FK Note 4416907.8 Bug 4416907 ORA-4020 DO_DEFERRED_REPCAT_ADMIN concurrent SQL Note 4329748.8 Bug 4329748 ORA-4020 / deadlock quiescing a replication group Note 4029101.8 Bug 4029101 Concurrent CREATE TABLE / VIEW can deadlock (ORA-60) Note 4275733.8 Bug 4275733 Deadlock between library cache lock and row cache lock from concurrent rename partition Note 4313246.8 Bug 4313246 PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks Note 4185270.8 Bug.4185270 PMON "failed to acquire row cache enqueue" cleaning a dead process Note 4446011.8 Bug.4446011 Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE Note 3987280.8 Bug.3987280 Concurrent GRANT / SET ROLE can hang / deadlock
Bugs Fixed in 10.1.0.4 and 10.2.0.1
Bugs Fixed in 10.2.0.2 Note 4153150.8 Bug.4153150 Deadlock on dc_rollback_segments from concurrent parallel load and undo segment creation Note 4382653.8 Bug.4382653 Deadlock / ORA-4020 gathering statistics on indices Note 4375798.8 Bug.4375798 ORA-60 deadlock from AQ enqueue Note 4552067.8 Bug.4552067 Deadlock / ORA-4020 using TRUNCATE SQL against global temporary tables Bugs Fixed in 10.2.0.3 Note 4627237.8 Bug.4627237 autonomous_transaction with DB link to shared server can self deadlock on DX Note 4732503.8 Bug.4732503 Self-deadlock on TT enqueue Note 4699610.8 Bug.4699610 can self deadlock waiting for MTTR state object which it holds Note 5386881.8 Bug.5386881 ORA-60 deadlock from terminal recovery Note 5363031.8 Bug.5363031 deadlock on broker metadata lock when FSFO is enabled Bugs Fixed in 10.2.0.4 Note 4768022.8 Bug.4768022 ALTER TABLE can fail with ORA-60 Note 5907779.8 Bug.5907779 Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS) Note 5983020.8 Bug.5983020 MMON deadlock with user session executing ALTER USER Note 5485914.8 Bug.5485914 Mutex self deadlock after DBMS_MONITOR.session_trace_enable Note 5685189.8 Bug.5685189 Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors Note 5557421.8 Bug.5557421 Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM Note 5604698.8 Bug.5604698 Deadlock between 'library cache lock' and 'library cache pin' using Streams Note 5415506.8 Bug.5415506 ORA-4020 when dbms_aqadm.purge_queue_table and select are run Note 4587572.8 Bug.4587572 ORA-12801/ORA-60 possible from parallel DML with grouping sets Note 5695131.8 Bug.5695131 HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment <> Bug.5941601 TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber Note 5998048.8 Bug.5998048 Deadlock on COMMIT updating AUD$ / Performance degradation when FGA is enabled Note 6057351.8 Bug.6057351 AWR deadlock between Mxxx processes during snapshot purging process Bugs Fixed in Future Releases (11G) Note 6368621.8 Bug.6368621 I/O slave creation time-outs, under extreme memory pressure Note 6644122.8 Bug.6644122 ON COMMIT refresh deadlock (library cache pin V lock) Note 5932196.8 Bug.5932196 Deadlock (ORA-4020) between MVIEW refresh and auto gather_stats_job Note 4896424.8 Bug.4896424 Parallel DML can fail with ORA-60 Note 5476091.8 Bug.5476091 Ctrl-C ignored for sessions waiting for mutexes Note 6618312.8 Bug.6618312 Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock) Note 5554054.8 Bug.5554054 AQ JMS deadlock between threads Note 6475688.8 Bug.6475688 Concurrent rewrite and on-commit refresh can deadlock (library cache pin ,lock) For summary of bugs which could cause deadlock in RAC see Note 554567.1 References NOTE:4416907.8 - Bug 4416907 - ORA-4020 from DO_DEFERRED_REPCAT_ADMIN with concurrent SQL NOTE:4446011.8 - Bug 4446011 - Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE NOTE:4552067.8 - Bug 4552067 - Deadlock / ORA-4020 using TRUNCATE SQL against global temporary tables NOTE:4587572.8 - Bug 4587572 - ORA-12801/ORA-60 possible from parallel DML with grouping sets NOTE:4627237.8 - Bug 4627237 - autonomous_transaction with DB link to shared server can self deadlock on DX NOTE:4699610.8 - Bug 4699610 - CKPT can self deadlock waiting for MTTR state object which it holds NOTE:4732503.8 - Bug 4732503 - Self-deadlock on TT enqueue NOTE:4768022.8 - Bug 4768022 - ALTER TABLE can fail with ORA-60 NOTE:4896424.8 - Bug 4896424 - Parallel DML can fail with ORA-60 NOTE:5363031.8 - Bug 5363031 - deadlock on broker metadata lock when FSFO is enabled NOTE:5386881.8 - Bug 5386881 - ORA-60 deadlock from terminal recovery NOTE:5415506.8 - Bug 5415506 - ORA-4020 when dbms_aqadm.purge_queue_table and select are run NOTE:5476091.8 - Bug 5476091 - Ctrl-C ignored for sessions waiting for mutexes / Deadlock with "enq: PS" - superceded NOTE:5485914.8 - Bug 5485914 - Mutex self deadlock on explain / trace of remote mapped SQL NOTE:5554054.8 - Bug 5554054 - AQ JMS deadlock between threads NOTE:5557421.8 - Bug 5557421 - Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM NOTE:5604698.8 - Bug 5604698 - Deadlock between 'library cache lock' and 'library cache pin' using replication NOTE:5685189.8 - Bug 5685189 - Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors NOTE:5695131.8 - Bug 5695131 - HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment NOTE:5907779.8 - Bug 5907779 - Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS) NOTE:5932196.8 - Bug 5932196 - Deadlock (ORA-4020) between MVIEW refresh and auto gather_stats_job NOTE:5983020.8 - Bug 5983020 - MMON deadlock with user session executing ALTER USER NOTE:5998048.8 - Bug 5998048 - Deadlock on COMMIT updating AUD$ / Performance degradation when FGA is enabled NOTE:6057351.8 - Bug 6057351 - AWR deadlock between Mxxx processes during snapshot purging process NOTE:6368621.8 - Bug 6368621 - I/O slave creation time-outs, under extreme memory pressure NOTE:6475688.8 - Bug 6475688 - Concurrent rewrite and on-commit refresh can deadlock (library cache pin <--> lock) NOTE:6618312.8 - Bug 6618312 - Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock) NOTE:6644122.8 - Bug 6644122 - ON COMMIT refresh deadlock (library cache pin V lock) BUG:2014833 - LOCKING ISSUE WITH USING PARTITIONS[This section is not visible to customers.] BUG:2615271 - PLE1158.10:INSTALL WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK![This section is not visible to customers.] BUG:2796282 - CONFLICTING DEADLOCK IDS FOR SESSIONS RESULT IN INCORRECT DEADLOCKS[This section is not visible to customers.]
BUG:2883771 - WAITED TOO LONG FOR ROWCACHE ENQUEUE WHEN USING RESOURCE MANAGER IN PL/SQL BUG:2918838 - UNDETECTED DEADLOCK FOR DC_TABLESPACE_QUOTAS AMONG TWO PROCESSES BUG:2995746 - DEAD LOCK BETWEEN SESSION DOING A GRANT AND OTHER SESSION PARSING A AGED CURSOR BUG:3001270 - DEADLOCK BETWEEN SMON AND FOREGROUND PROCESS FOR OBJECT USER$[This section is not visible to customers.] BUG:3009268 - SMON WAITS FOR A BUFFER WITH 'BUFFER BUSY WAIT' UNREASONABLY BUG:3030298 - ORA-600[2103] OCCURED WHEN WE EXECUTED 'DROP TABLESPACE AND DATAFILES' ON PARALL BUG:3080929 - STAR : WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK![This section is not visible to customers.] BUG:3093080 - ALTER TABLE ENABLE TABLE LOCK CAN CAUSE A DEADLOCK[This section is not visible to customers.] BUG:3166756 - FALSE DEAD LOCK WITH XA ORA-60 SIMILAR BUT NOT EXACT TO BUG1994858 BUG:3261205 - ORA-00600: [KXTTDROPOBJ-1], [0], [4229477] ON PIDL INTO TXN DURATION TEMP TABLE[This section is not visible to customers.] BUG:3271271 - QMON CAN DEADLOCK WITH JOB QUEUE PROCESSES BUG:3314850 - CRM - 9.2: CIRCULAR DEADLOCK BETWEEN 'DROP SUMMARY' AND SUMMARY REWRITE[This section is not visible to customers.] BUG:3320292 - PARALLEL RECOMPILATION HANGS WHEN RECOMPILING TYPE GENERATED FOR PIPELINE FUNC[This section is not visible to customers.] BUG:3381218 - DEADLOCK BETWEEN 'LIBRARY CACHE PIN' AND 'LIBRARY CACHE LOCK'. BUG:3398485 - DEADLOCK DURING ON DEMAND MATERIALIZED VIEW REFRESH ORA-04020 BUG:3424721 - SESSION HANGS WHEN PERFORMING REBUILD AND ANALYZE ON THE SAME INDEX PARTITION[This section is not visible to customers.] BUG:3540821 - ORA-4020 DEADLOCK DETECTED BY J000 AND M000[This section is not visible to customers.] BUG:3562032 - SERVERS HANG IN TWO CONCURRENT RUNS: ALTER INDEX REBUILD ONLINE; AND UPDATE DML[This section is not visible to customers.] BUG:3605165 - DATABASE HANGING ISSUE.. SEEMS LIKE LIBRARY CACHE PIN WAITS BUG:3717619 - DATABASE HANG DUE TO LIBRARY CACHE PIN WAITS AND LIBRARY CACHE LOAD LOCK WAIT[This section is not visible to customers.] BUG:3756949 - SEQUENCES CAN DEADLOCK ON SPACE ALLOCATION FAILURE[This section is not visible to customers.] BUG:3896974 - ORA-4020 CREATING DIMENSIONS FROM SCHEMAS SIMULTANEOUSLY BUG:3975268 - GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED[This section is not visible to customers.] BUG:3987280 - CHANGING A ROLE WILL NOT ALLOW FURTHER LOGINS UNDER SPECFIC CIRCUMSTANCES BUG:3990235 - DEADLOCK IN DISK DROP AND INSTANCE RECOVERY BUG:4008775 - APPSPERF: DBMS_SPACE CALLED WITH DBMS_STATS[This section is not visible to customers.] BUG:4029101 - CONCURRENT IMPDB DEADLOCK ORA-60[This section is not visible to customers.] BUG:4114238 - DEADLOCK BETWEEN DC_USERS AND DC_USERNAMES ROW CACHE LOCK BUG:4137000 - DEADLOCK 'LIBRARY CACHE LOCK' - 'ROW CACHE LOCK' DURING CONCURRENT SPLITTING BUG:4153150 - SQL*LOADER HANGS WITH ROW CACHE LOCK (DC_ROLLBACK_SEGMENTS)[This section is not visible to customers.] BUG:4185270 - PMON "FAILED TO ACQUIRE ROW CACHE ENQUEUE", PROCESS DEAD MOVING HW TEMPORARY SEG BUG:4275733 - DEADLOCK BETWEEN LIBRARY CACHE LOCK AND ROW CACHE LOCK BUG:4313246 - DEADLOCK BETWEEN DC_USERS AND DC_USERNAMES ROW CACHE LOCK BUG:4375798 - ORA-00060: DEADLOCK DETECTED WHILE WAITING FOR RESOURCE[This section is not visible to customers.] BUG:4382653 - ORA-4020 IS RAISED WITH SIMULTANEOUS DBMS_STAT.SET BUG:4416907 - ORA-4020 FROM DO_DEFERRED_REPCAT_ADMIN WITH SIMULTANEOUS SELECTS[This section is not visible to customers.] BUG:4446011 - HANG WITH ROW CACHE ENQUEUE LOCK BUG:4552067 - DEADLOCKS USING TRUNCATE ON SESSION SPECIFIC GLOBAL TEMPORARY TABLES[This section is not visible to customers.] BUG:4587572 - APPSST102 :ORA-12801/ORA-00060 IS RAISED FOR PARALLEL DML[This section is not visible to customers.] BUG:4627237 - AUTONOMOUS_TRANSACTION WITH DBLINK TO SHARED SERVER CAN GET SELF DEADLOCK ON DX[This section is not visible to customers.] BUG:4699610 - SMON BLOCKING OTHER SESSIONS[This section is not visible to customers.] BUG:4732503 - SELF-DEADLOCK TT ENQUEUE ON 9.2.0.7 SIMILAR TO 3425298 BUG:4768022 - ALTER TABLE FAILS WITH ORA-2050,ORA-60 IF TABLE HAS MVIEW, TRIGGER, DBLINK BUG:4896424 - ORA-00060 ERRORS USING PARALLEL PROCESSING[This section is not visible to customers.] BUG:5363031 - DEADLOCK ON BROKER METADATA LOCK WHEN FSFO IS ENABLED[This section is not visible to customers.] BUG:5386881 - KRSMISRL_INTERNAL USES INCORRECT BRANCH INFO[This section is not visible to customers.] BUG:5415506 - ORA-4020 OCCURS WHEN DBMS_AQADM.PURGE_QUEUE_TABLE AND SELECT ARE RUN BUG:5476091 - ALTER INDEX REBUILD DEADLOCK: PROCESS HANGING WAITING FOR 'CURSOR: PIN X' BUG:5485914 - MUTEX REPORTED SELF DEADLOCK AFTER DBMS_MONITOR.SESSION_TRACE_ENABLE BUG:5554054 - DEADLOCK BETWEEN THREADS :AQJMSSESSION.REMOVECONSUMER AND AQJMSCONSUMER.DEQUEUE BUG:5557421 - SELF-DEADLOCK OCCURS WHEN IMP SESSION IS KILLED[This section is not visible to customers.] BUG:5604698 - DEADLOCK BETWEEN 'LIBRARY CACHE LOCK' AND 'LIBRARY CACHE PIN' BUG:5685189 - GATHER AUTO MODE WAITING ON DR$IBE_CT_IMEDIA_SEARCH BUG:5695131 - HW ENQUEUE DEADLOCK OCCURS WHILE INSERTING BUG:5907779 - "CURSOR: PIN S WAIT ON X" RUNNING DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC
BUG:5932196 - DEADLOCK BETWEEN MV_REFRESH (DEL) AND AUTO GATHER_STATS_JOB[This section is not visible to customers.] BUG:5941601 - TRANSACTION DEADLOCK / OJMS AND DBMS_AQADM_SYS.ALTER_SUBSCRIBER() BUG:5983020 - MUTEX AND ROW CACHE DEADLOCK BUG:5998048 - PERFORMANCE DEGRADATION WITH FGA ENABLED BUG:6057351 - TWO BACKGROUND PROCESS THAT ARE LOCKING EACH OTHER OUT. M000 AND M001 BUG:6368621 - IO SLAVES DEAD LOCK PROBLEM IN 64BIT PLATFORMS.[This section is not visible to customers.] BUG:6475688 - MV UPDATE CAUSES A LIBCACHE PIN <--> LOCK DEADLOCK BUG:6618312 - MV UPDATE: LIBCACHE PIN <--> LOCK DEADLOCK EVEN WITH FIX FOR BUG 6475688[This section is not visible to customers.] BUG:6644122 - LIBCACHE PIN <--> LOCK DEADLOCK EVEN WITH FIX FOR BUG 6618312[This section is not visible to customers.] NOTE:2014833.8 - Bug 2014833 - Deadlock possible from concurrent SELECT and TRUNCATE NOTE:2615271.8 - Bug 2615271 - Deadlock from concurrent GRANT and logon NOTE:2796282.8 - Bug 2796282 - False deadlock possible using shared servers NOTE:2883771.8 - Bug 2883771 - "WAITED TOO LONG FOR ROWCACHE ENQUEUE" when using Resource Manager in PLSQL NOTE:2918838.8 - Bug 2918838 - Undetected deadlock for dc_tablespace_quotas among two processes NOTE:2995746.8 - Bug 2995746 - Deadlock between session doing a GRANT and another session parsing an aged out cursor NOTE:3001270.8 - Bug 3001270 - Deadlock between SMON and foreground process for dc_suers NOTE:3009268.8 - Bug 3009268 - User sessions waiting for recovery of DEAD prepared TX may deadlock with SMON NOTE:3030298.8 - Bug 3030298 - OERI:2103 from concurrent 'drop tablespace including datafiles' NOTE:3080929.8 - Bug 3080929 - ORA-4021 / hang can occur due to SMON self deadlock on UNDO$ row cache lock NOTE:3093080.8 - Bug 3093080 - ALTER TABLE ENABLE TABLE LOCK can cause a deadlock NOTE:3166756.8 - Bug 3166756 - Self deadlock (ORA-60) / OERI possible on LOB index update NOTE:3261205.8 - Bug 3261205 - Hang / OERI[kxttdropobj-1] on parallel direct load to temporary table NOTE:3271271.8 - Bug 3271271 - QMON can deadlock with job queue processes NOTE:3314850.8 - Bug 3314850 - DROP SUMMARY can deadlock with query rewrite sessions NOTE:3320292.8 - Bug 3320292 - Parallel recompilation hangs when recompiling type generated for pipeline function NOTE:3381218.8 - Bug 3381218 - Deadlock involving 'library cache lock' X mode request NOTE:3398485.8 - Bug 3398485 - Deadlock during on demand materialized view refresh (ORA-4020) NOTE:3424721.8 - Bug 3424721 - Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL NOTE:3540821.8 - Bug 3540821 - ORA-4020 deadlock from concurrent ANALYZE index / query compilation against a cluster NOTE:3562032.8 - Bug 3562032 - Cancelled ONLINE index rebuild can deadlock with DML session NOTE:3605165.8 - Bug 3605165 - Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger NOTE:3717619.8 - Bug 3717619 - Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger NOTE:3756949.8 - Bug 3756949 - Sequences can deadlock on space allocation failure NOTE:3896974.8 - Bug 3896974 - ORA-4020 creating DIMENSIONs from schemas simultaneously NOTE:3975268.8 - Bug 3975268 - Deadlock possible after gathering statistics for certain SYS objects NOTE:3987280.8 - Bug 3987280 - Concurrent GRANT / SET ROLE can hang / deadlock NOTE:3990235.8 - Bug 3990235 - Deadlock in disk drop and instance recovery in ASM NOTE:4008775.8 - Bug 4008775 - Self deadlock calling DBMS_SPACE / DBMS_STATS in same user call NOTE:4029101.8 - Bug 4029101 - Concurrent CREATE TABLE / VIEW can deadlock (ORA-60) NOTE:4114238.8 - Bug 4114238 - Deadlock between dc_users and dc_usernames row cache lock enabling FK NOTE:4137000.8 - Bug 4137000 - Concurrent SPLIT PARTITION can deadlock / hang NOTE:4153150.8 - Bug 4153150 - Deadlock on dc_rollback_segments from concurrent parallel load and undo segment creation NOTE:4185270.8 - Bug 4185270 - PMON "failed to acquire row cache enqueue" cleaning a dead process NOTE:4275733.8 - Bug 4275733 - Deadlock between library cache lock and row cache lock from concurrent rename partition NOTE:4313246.8 - Bug 4313246 - PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks NOTE:4329748.8 - Bug 4329748 - ORA-4020 / deadlock quiescing a replication group NOTE:4375798.8 - Bug 4375798 - ORA-60 deadlock from AQ enqueue NOTE:4382653.8 - Bug 4382653 - Deadlock / ORA-4020 gathering statistics on indices
Leave a Reply