SYS@TESH996P SQL> select min(snap_id), min(sample_time), max(snap_id),max(sample_time) from dba_hist_active_sess_history where sample_time < to_date('20-JUL-18','DD-MON-YY');
MIN(SNAP_ID) MIN(SAMPLE_TIME)
------------ ---------------------------------------------------------------------------
MAX(SNAP_ID) MAX(SAMPLE_TIME)
------------ ---------------------------------------------------------------------------
72277 18-JUL-18 11.00.39.789 PM
72326 19-JUL-18 11.59.48.043 PM
1 row selected.
To know the retenetion:
------------------------------------
SYS@TESH996P SQL> select DBID,RETENTION,SNAP_INTERVAL from dba_hist_wr_control;
DBID RETENTION SNAP_INTERVAL
---------- ---------------------------------------- --------------------------------------------------
1857388495 +00090 00:00:00.0 +00000 00:30:00.0
1 row selected.
Cretae baseline:
---------------------
exec DBMS_WORKLOAD_REPOSITORY.create_baseline(72277,72326,'Test Baseline');
PL/SQL procedure successfully completed.
To view the baseline:
-------------------------
SYS@TESH996P SQL> SELECT baseline_id,baseline_name,baseline_type,start_snap_id,end_snap_id FROM dba_hist_baseline;
BASELINE_ID BASELINE_NAME BASELINE_TYPE START_SNAP_ID END_SNAP_ID
----------- ------------------------------------------------------------ --------------------------------------- ------------- -----------
8 Test Baseline STATIC 76691 76738
1 EOD BASELINE 13/AUG/2018 MON STATIC 73479 73492
Delete baseline:
-------------------
SYS@TESH996P SQL> exec DBMS_WORKLOAD_REPOSITORY.drop_baseline(BASELINE_NAME => 'Test Baseline');
PL/SQL procedure successfully completed.
SYS@TESH996P SQL> SELECT baseline_id,baseline_name,baseline_type,start_snap_id,end_snap_id FROM dba_hist_baseline;
BASELINE_ID BASELINE_NAME BASELINE_TYPE START_SNAP_ID END_SNAP_ID
----------- ------------------------------------------------------------ --------------------------------------- ------------- -----------
1 EOD BASELINE 13/AUG/2018 MON STATIC 73479 73492
MIN(SNAP_ID) MIN(SAMPLE_TIME)
------------ ---------------------------------------------------------------------------
MAX(SNAP_ID) MAX(SAMPLE_TIME)
------------ ---------------------------------------------------------------------------
72277 18-JUL-18 11.00.39.789 PM
72326 19-JUL-18 11.59.48.043 PM
1 row selected.
To know the retenetion:
------------------------------------
SYS@TESH996P SQL> select DBID,RETENTION,SNAP_INTERVAL from dba_hist_wr_control;
DBID RETENTION SNAP_INTERVAL
---------- ---------------------------------------- --------------------------------------------------
1857388495 +00090 00:00:00.0 +00000 00:30:00.0
1 row selected.
Cretae baseline:
---------------------
exec DBMS_WORKLOAD_REPOSITORY.create_baseline(72277,72326,'Test Baseline');
PL/SQL procedure successfully completed.
To view the baseline:
-------------------------
SYS@TESH996P SQL> SELECT baseline_id,baseline_name,baseline_type,start_snap_id,end_snap_id FROM dba_hist_baseline;
BASELINE_ID BASELINE_NAME BASELINE_TYPE START_SNAP_ID END_SNAP_ID
----------- ------------------------------------------------------------ --------------------------------------- ------------- -----------
8 Test Baseline STATIC 76691 76738
1 EOD BASELINE 13/AUG/2018 MON STATIC 73479 73492
Delete baseline:
-------------------
SYS@TESH996P SQL> exec DBMS_WORKLOAD_REPOSITORY.drop_baseline(BASELINE_NAME => 'Test Baseline');
PL/SQL procedure successfully completed.
SYS@TESH996P SQL> SELECT baseline_id,baseline_name,baseline_type,start_snap_id,end_snap_id FROM dba_hist_baseline;
BASELINE_ID BASELINE_NAME BASELINE_TYPE START_SNAP_ID END_SNAP_ID
----------- ------------------------------------------------------------ --------------------------------------- ------------- -----------
1 EOD BASELINE 13/AUG/2018 MON STATIC 73479 73492