AWR reports MANUAL SNAPSHOT

AWR reports MANUAL SNAPSHOT  
------------------------------------------------------
SQL> exec dbms_workload_repository.create_snapshot; 

PL/SQL procedure successfully completed.
------------------------------------------------------
As well we can change the retention period and the snapshot interval. In the example below we change the 

retention period to 5 days ( 5 x 24 x 60 ) and the snapshot interval to 30 minutes.

------------------------------------------------------
SQL> exec dbms_workload_repository.modify_snapshot_settings (retention => 7200,interval => 30);

PL/SQL procedure successfully completed.


select * from dba_hist_wr_control;


exec DBMS_WORKLOAD_REPOSITORY.drop_snapshot_range (low_snap_id  => 3020,high_snap_id => 3040);

------------------------------------------------------