Search notes:

Oracle: DBA_HIST_ASH_SNAPSHOT

select
   asn.begin_interval_time,
   asn.end_interval_time,
   asn.bl_moved,
   asn.con_id,
   asn.dbid,
   asn.error_count,
   asn.flush_elapsed,
   asn.instance_number,
   asn.snap_flag,
   asn.snap_id,
   asn.snap_level,
   asn.snap_timezone,
   asn.startup_time,
   asn.status
from
   sys.dba_hist_ash_snapshot asn
order by
   asn.begin_interval_time desc;

select
   case when vdb.dbid = asn.dbid then '*' end e,
   asn.dbid,
   count(*)                     cnt,
   min(asn.begin_interval_time) min_t,
   max(asn.  end_interval_time) max_t
from
   v$database            vdb   cross join
   dba_hist_ash_snapshot asn
group by
   asn.dbid,
   vdb.dbid
;

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...', 1758206880, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/hist/ash/snapshot/index(77): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle: DBA_HIST_ASH_SNAPSHOT

See also