Database Not Generating ASH Reports
(Doc ID 1529808.1)
Last updated on APRIL 18, 2024
Applies to:
Exadata Database Machine X2-2 Full Rack - Version All Versions to All Versions [Release All Releases]Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Running ashrpt fails with following error:
*
ERROR at line 1:
ORA-20200: No ASH samples exist for Database/Instance 221894972/1
ORA-06512: at line 39
* statistics_level parameter is set to TYPICAL
* AWR reports (both instance level and RAC level) are getting generated properly and we can see the accurate data in the reports.
Looking at the underlying tables:
SQL> select count(*) from SYS.WRH$_ACTIVE_SESSION_HISTORY;
COUNT(*)
----------
0
SQL> select * from x$KEWASH;
no rows selected
SQL> select * from x$ash;
no rows selected
SQL> select a.ksppinm parameter,b.ksppstvl value from x$ksppi a,x$ksppcv b where a.indx=b.indx and ksppinm='_ash_enable';
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
_ash_enable
TRUE
Changes
Possible changes to the AWR settings/Parameters
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 |