Automatic Workload Repository (AWR) Snapshots Are Not Generated in 12c on AIX 7.1
(Doc ID 2316944.1)
Last updated on MAY 12, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
Symptoms
- After an upgrade from 11.2.0.4 to 12.1.0.2 on AIZ 7.1 AWR snapshots are not being generated
- The following may be present in an MMON trace file:
QOSD flushing KSXM hash table failed with error 12751
- The TKPROF output on an mmon slave trace will show unrealistic numbers for CPU
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 1008808533.70 0.40 73 136 2149 462 <-----NOTE: The unrealistic values for cpu under the execute phase.
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 1008808533.70 0.40 73 136 2149 462
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 |