Search notes:

Oracle: V$ASH_INFO

v$ash_info shows some information about the Active Session History sampling process.
v$ash_info is not documented.
select
  inst_id,
  sampling_interval                                                      sampling_interval_ms, -- Assumption!
  extract(hour   from latest_sample_time - oldest_sample_time) * 60 +
  extract(minute from latest_sample_time - oldest_sample_time)           minutes_stored,

  to_char(oldest_sample_time, 'hh24:mi:ss')                              oldest_sample,
  to_char(latest_sample_time, 'hh24:mi:ss')                              latest_sample,
  sample_count                                                           cnt_samples,
  to_char(sampled_bytes / 1024/1024, '999.00')                           size_sampled_mb,      -- ?
  to_char(total_size    / 1024/1024, '999.00')                           size_mb,
  sampler_elapsed_time,
  awr_flush_count,
  awr_flush_emergency_count,
  disk_filter_ratio
from
  gv$ash_info
;
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/ash_info/show.sql

See also

Oracle Dynamic Performance Views

Index