Sudden Increase of ASH Data Without Any Additional Database Activities (Doc ID 2786239.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

• It is possible that ASH data increased suddenly without any clear reason:
  For example,

  select dbid, to_char(sample_time, 'YYYYMMDD') sample_date, count(*)
  from WRH$_ACTIVE_SESSION_HISTORY
  group by dbid, to_char(sample_time, 'YYYYMMDD')
  order by dbid, to_char(sample_time, 'YYYYMMDD');

  DBID SAMPLE_DATE COUNT(*)
  ---------- ------------- ----------
  ...........................................
  2846234058 20210615 2246
  2846234058 20210616 2500
  2846234058 20210617 3120
  2846234058 20210618 1612062 <<#### Sudden increase
  2846234058 20210619 4530658

  Why and how to fix it?

   

Solution

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