AWR Snapshots Not Generated With "Reliable Messages" Waits

Last updated on DECEMBER 21, 2017

Applies to:

Symptoms

• Automatic AWR snapshots not working even after bouncing the database or recreating AWR per <Document 782974.1>
• No m00 trace file produced or no messages in the alert log
• Manual AWR snapshot shows all time spent on "reliable messages":  
  BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); END;

  call count cpu elapsed disk query current rows
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  Parse 1 0.03 0.07 6 80 0 0
  Execute 1 14.62 900.43 3215 41 39 1
  Fetch 0 0.00 0.00 0 0 0 0
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  total 2 14.66 900.51 3221 121 39 1

  Event waited on Times Max. Wait Total Waited
  ---------------------------------------- Waited ---------- ------------
  reliable message 1 900.00 900.00

    
  

   

  
  
  
  

Cause