library cache: mutex x waits during AWR Flush High Cursor Scan
(Doc ID 2382741.1)
Last updated on JULY 01, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
AWR flush waiting for cursor scan, library cache : mutex X.
MMON slave errors out with : ORA-12751: cpu time or run time policy violation
From M000 trace file:
*** SERVICE NAME:(SYS$BACKGROUND) 2018-02-03 15:49:14.183
*** MODULE NAME:(MMON_SLAVE) 2018-02-03 15:49:14.183
*** ACTION NAME:(Auto-Flush Slave Action) 2018-02-03 15:49:14.183
DDE rules only execution for: ORA 12751
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
Executing ASYNC actions
----- START DDE Action: 'ORA_12751_DUMP' (Sync) -----
Runtime exceeded 900 seconds
Time limit violation detected at:
ksedsts <- kspol_12751_dump <- dbgdaExecuteAction <- dbgerRunAction <- dbgerRunActions <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeselv <- kgxWait <- kgxExclusive <- kglGetMutex <- kglGetBucketMutex <- kglic0 <- kksIterCursorStat <- kewrrtsq_rank_topsql <- kewrbtsq_build_topsql <- kewrftsq_flush_topsql <- kewrft_flush_table <- kewrfat_flush_all_tables <- kewrfos_flush_onesnap <- kewrfsc_flush_snapshot_c <- kewrafs_auto_flush_slave <- kebm_slave_main <- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |