My Oracle Support Banner

Database Not Generating ASH Reports (Doc ID 1529808.1)

Last updated on AUGUST 04, 2018

Applies to:

Exadata Database Machine X2-2 Full Rack - Version All Versions to All Versions [Release All Releases]
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


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;


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';






 Possible changes to the AWR settings/Parameters


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.