AWR Snapshots Not Generated With "Reliable Messages" Waits
(Doc ID 2340420.1)
Last updated on JULY 15, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
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 1Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
reliable message 1 900.00 900.00
Changes
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 |
Changes |
Cause |
Solution |
References |