Database Not Generating ASH Reports (Doc ID 1529808.1)

Last updated on MARCH 02, 2017

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]
Information in this document applies to any platform.

Symptoms

Running ashrpt fails with following error:

declare
*
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

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 hundreds of Community platforms