Oracle snapshot Management

Oracle snapshot Management

---- Manually create an Oracle Snapshot
BEGIN
DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
END;
/

--- Delete a snapshot
For more information about snapshots, see DBA_HIST_SNAPSHOT.
 
BEGIN
DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE (low_snap_id => 22,
High_snap_id = & gt; 32, dbid = & gt; 3310949047 );
END;
/
 

--- Modify snapshot settings
BEGIN
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (retention => 43200, interval => 30, topnsql => 100, dbid => 3310949047 );
END;
/
 
/* Retention: 43200 minutes (30 days); interval: 30 minutes; topsql :*/
View the current snapshot parameter configuration through DBA_HIST_WR_CONTROL.

Oracle Database ORA-01555 snapshot old

Oracle ORA-01555 snapshot old description

Snapshot control file)

Oracle Tutorial: Snapshot Control File

How to synchronize two databases in Oracle (using the materialized view) (Oracle snapshot instance)