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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758205468, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/dynamic-performance-views/ash_info/index(61): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78