You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and
you have been getting notifications whenever the database performance degrades. You optimize the
database I/O to gain the performance and you decide to remove the baseline metrics. Which
method would you use to remove the DISK_IO_BL baseline metrics?
A.
The baseline, once created, cannot be removed.
B.
Disable the baseline metrics in the Database Control Manage Metrics page.
C.
The baseline will be automatically removed once the database performance has been optimized.
D.
Drop the baseline metrics by using DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
DROP_BASELINE Procedure
This procedure drops a baseline.
Syntax
DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE(
baseline_name IN VARCHAR2,
cascade IN BOOLEAN DEFAULT false,
dbid IN NUMBER DEFAULT NULL);
Parameters
Table 119-14 DROP_BASELINE Parameters
Parameter Description
baseline_name
The name of baseline.
cascade
If TRUE, the pair of snapshots associated with the baseline will also be dropped. Otherwise, only the baseline is removed.
dbid
The (optional) database id (default to local DBID).
DBMS_WORKLOAD_REPOSITORY has DROP_BASELINE Procedure