Oracle snapshot management, oraclesnapshot
Zookeeper
---- 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.
How to manually refresh the snapshot in Oracle ??
It seems impossible between oracle7.3 Group servers! ORA-06508: PL/SQL: cocould not find program unit being called I use SYS. DBMS_SNAPSHOT.REFRESH: ORA-04068: existing state of packages has been discarded ORA-04063: package body "SYS. DBMS_SNAPSHOT "has errors ORA-06512: at line 2 view original post>
Snapshot of oracle
Snapshot is a snapshot.
An oracle Database snapshot is a table that contains query results for one or more tables or views on a local or remote database. Similar to the query subset of the primary table, snapshots can be used to speed up data query. Snapshots can be used to refresh two tables in different databases during synchronization, the data update performance will also be greatly improved.