AWR – Base Line

* When you optimizing your database using AWR, you can create “Base Line” to compare the values with other snapshots.

–> For example, if you want to compare statistics before and after the turning.
SQL> BEGIN
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE(
START_SNAP_ID => 33873,
END_SNAP_ID => 33883,
BASELINE_NAME => ‘GOOD_SNAP’ );
END;
/

* Drop Base Line ( You can drop the baseline if you don’t need it any more.)
–> Baseline snapshopt doest not automatally purged, So, you should manually drop the baseline when you don’t need it anymore.

SQL> BEGIN
DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE(
BASELINE_NAME => ‘GOOD_SNAP’,
CASCADE => TRUE );
END;
/

* Review Baseline information
SQL> SELECT * FROM DBA_HIST_BASELINE;

Advertisement