Oracle Snapshot (snapshot) management



----Create an Oracle snapshot manually
BEGIN
Dbms_workload_repository. Create_snapshot ();
END;
/

---delete a snapshot
Specific snapshot information can be viewed in view Dba_hist_snapshot

BEGIN
Dbms_workload_repository. Drop_snapshot_range (low_snap_id = 22,
high_snap_id = +, dbid = 3310949047);
END;
/

---modify snapshot settings
BEGIN
Dbms_workload_repository. Modify_snapshot_settings (retention = 43200, interval, topnsql = 3310949047);
END;
/

/* retention:43200 minutes (days); interval:30 minutes; Topsql: */
View the current snapshot parameter configuration through View Dba_hist_wr_control.