The dbms_workload_repository package is manage
the AWR snapshot in Oracle. We will
use dbms_workload_repository table
for creation and deletion AWR snapshot in Oracle.
Create AWR snapshot:
SQL> EXEC
dbms_workload_repository.create_snapshot;
OR
SQL> select
dbms_workload_repository.create_snapshot('ALL') from dual;
SQL> select end_interval_time, error_count from DBA_HIST_SNAPSHOT where snap_id
=190;
Delete AWR snapshot:
SQL> EXEC
dbms_workload_repository.drop_snapshot_range
2 (low_snap_id=>185, high_snap_id=>187);