library cache: mutex x waits during AWR Flush High Cursor Scan

(Doc ID 2382741.1)

Last updated on APRIL 14, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 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()+465<-kspol_12751_dump()+145<-dbgdaExecuteAction()+1065<-dbgerRunAction()+109<-dbgerRunActions()+4134<-dbgexPhaseII()+1873<-dbgexProcessError()+2680<-dbgeExecuteForError()+88<-dbgePostErrorKGE()+2136<-dbkePostKGE_kgsf()+71<-kgeselv()+276<-kgesecl0()+139
<-kgxWait()+1412<-kgxExclusive()+447<-kglGetMutex()+140<-kglGetBucketMutex()+69<-kglic0()+271<-kksIterCursorStat()+330<-kewrrtsq_rank_topsql()+240<-kewrbtsq_build_topsql()+128<-kewrftsq_flush_topsql()+679<-kewrft_flush_table()+397<-kewrftec_flush_table_ehdlcx()+766
<-kewrfat_flush_all_tables()+1406<-kewrfos_flush_onesnap()+170<-kewrfsc_flush_snapshot_c()+623<-kewrafs_auto_flush_slave()+769<-kebm_slave_main()+586<-ksvrdp()+1766<-opirip()+674<-opidrv()+603<-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253

 

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