Automatic Workload Repository (AWR) Snapshots Are Not Generated in 12c on AIX 7.1

Last updated on OCTOBER 12, 2017

Applies to:

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