AWK – Review Snapshot information

You can review snapshot information with below query.

SQL> alter session set nls_date_format=’yyyy/mm/dd hh24:mi:ss’;
SQL> select snap_id,instance_number,startup_time,begin_interval_time,end_interval_time
from dba_hist_snapshot
order by instance_number,snap_id
/

Advertisement