You can drop a range of snapshots using the DROP_SNAPSHOT_RANGE procedure. To
view a list of the snapshot Ids along with database Ids, check the
DBA_HIST_SNAPSHOT view. For example, you can drop the following range of snapshots:
BEGIN
DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE (low_snap_id => 22,
high_snap_id => 32, dbid => 3310949047);
END;
/
In the example, the range of snapshot Ids to drop is specified from 22 to 32. The
optional database identifier is 3310949047. If you do not specify a value for dbid,
the local database identifier is used as the default value.
Active Session History data (ASH) that belongs to the time period specified by the
snapshot range is also purged when the DROP_SNAPSHOT_RANGE procedure is called.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1004849/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002849
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
