Creation of AWR Snapshots is Hung Because MMON is Waiting for "Wait for EMON to process Ntfns" (Doc ID 2437945.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

• Creation of AWR Snapshots is hung because MMON is waiting for "'wait for EMON to process ntfns":
  

  Hang Analysis

  -------------------------------------------------------------------------------
  Chain 1:
  -------------------------------------------------------------------------------
  Oracle session identified by:
  {
  instance: 2 (TEST)
  os id: 18743436
  process id: 99, oracle@test(TNS V1-V3)
  session id: 98
  session serial #: 49922
  }
  is waiting for 'reliable message' with wait info:
  {
  p1: 'channel context'=0x700010278878c88
  p2: 'channel handle'=0x70001027c6a7850
  p3: 'broadcast message'=0x70001011919e140
  time in wait: 8 min 13 sec
  timeout after: 6 min 46 sec
  wait id: 5655
  blocking: 0 sessions
  current sql: BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); END;
  short stack: ksedsts()+712<-ksdxfstk()+44<-ksdxcb()+896<-sspuser()+220<-__sighandler()<-thread_wait()+556<-sskgpwwait()+52<-skgpwwait()+268<-ksliwat()+7912<-kslwaitctx()+192<-ksrpubwait_ctx()+2356<-ksrpubwait()+28<-kewrgrfr_get_remflush_replies()+40<-kewrfmsp2_fos_srcdb_part2()+208<-kewrfosp2_fos_mdb_part2()+148<-kewrfos_flush_onesnap()+172<-kewrfsc_flush_snapshot_c()+824<-kewrcmdbs_flush_mdb_snap()+608<-kewrpcs_create_snapshot_i()+816<-kewrpcstx_create_snapshot_wtxn()+652<-kewrpcs_create_snapshot_switch_cbk()+92<-kewrpcs_crea
  .....................
  }
  and is blocked by
  => Oracle session identified by:
  {
  instance: 2 (test.test2)
  os id: 14680314
  process id: 35, oracle@test02 (MMON)
  session id: 89
  session serial #: 64105
  }
  which is waiting for 'wait for EMON to process ntfns' with wait info:
  {
  time in wait: 1.309575 sec
  heur. time in wait: 118 min 31 sec
  timeout after: 3.690425 sec
  wait id: 28106153
  blocking: 1 session
  current sql: <none>
  short stack: ksedsts()+712<-ksdxfstk()+44<-ksdxcb()+896<-sspuser()+220<-__sighandler()<-thread_wait()+556<-sskgpwwait()+52<-skgpwwait()+268<-ksliwat()+7912<-kslwaitctx()+192<-kslwait()+108<-kponpst()+2360<-kwqicocipost()+1068<-kwqicpost()+1064<-ktcccDeleteCommitCallbacks()+1580<-ktcccdel()+32<-ktccpcmt()+644<-ktcCommitTxn_new()+15768<-ktcCommitTxn()+104<-keltpost_root()+352<-keltpost()+1168<-keltpost_sep_tran()+340<-kelr_issue_alert()+488<-kelr_check_for_violations()+2516<-kelr_monitor_metrics()+5836<-ksb_run_managed_action()+
  ................

Changes

Cause

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