Deadlock Between 'library cache lock' and 'enq: TM - contention' When Creating Index in Parallel (Doc ID 1929733.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

• Creating an index using the parallel clause fails with ORA-00060: deadlock detected De
• Deadlock is between 'enq: TM - contention' and 'library cache lock'
• One or more slave trace files will show that the current statement is a drop of a table in the recycle bin as shown in the following example:  

Cause