Which method would you use to remove the DISK_IO_BL baseline metrics?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


ish

ish

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).

ish

ish

DBMS_WORKLOAD_REPOSITORY has DROP_BASELINE Procedure