My Oracle Support Banner

library cache: mutex x waits during AWR Flush High Cursor Scan (Doc ID 2382741.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.