DEADLOCK(ORA-00060) BETWEEN GATHER STATS JOB AND MMON SLAVE(M00X)
Last updated on NOVEMBER 14, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
- MMON SLAVE(M00X) process Errors with ORA-00060 deadlock error in alter log
- Deadlock is between MMON SLAVE(M00X) and GATHER DB STATS JOB(J000)
- Also may see the Chain Signature in trace file like 'library cache lock'<='row cache lock' (cycle)
- The operation of MMON SLAVE(M00X) likes "alter table <TABLE NAME> split partition...",and the split table maybe WRH$_XXX tables like WRH$_TABLESPACE_STAT, WRH$_DB_CACHE_ADVICE,WRH$_ACTIVE_SESSION_HISTORY etc.
- The operation of GATHER DB STATS JOB may be gather_database_stats_job_proc
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