ORA-60 Received from DBMS_STATS Execution (Doc ID 1391781.1)

Last updated on JANUARY 05, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


Deadlock detected running DBMS_STATS:
ORA-12012: error on auto execute of job 591663
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.DBMS_STATS", line 18566
ORA-06512: at "SYS.DBMS_STATS", line 19051
ORA-06512: at "SYS.DBMS_STATS", line 19132
ORA-06512: at "SYS.DBMS_STATS", line 19088
ORA-06512: at line 2

Statistics is being collected on a SYS owned object

The *dia0* trace file indicates the following signature:
Chain Signature: 'library cache lock'<='row cache lock' (cycle)

It also indicates that the deadlocked processes were:
Resolving deadlock by signaling ORA-00060 to 'instance: 1, os id: 3604, session id: 897'
dump location: <oracle_base>/trace/<orasid>_j000_3604.trc

Performing diagnostic dump on 'instance: 1, os id: 8414, session id: 690'
dump location: <oracle_base>/trace/<orasid>_m004_8414.trc

M00* call stack indicates that AWR purge operation is underway:
ksliwat  kslwaitctx kqrget kqrpre1 kqrpre kkdlobni1 kkdlobni kkdlobn
kkpogppi_get_pruned_part_info kewrgpil_get_pinfo_list
kewrppbs_purge_partn_bysid kewrpap_purge_all_partitions...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms