Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline template.

Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline
template.

Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline
template.

A.
when creating AWR snapshots based on a repeating time schedule

B.
when creating and dropping AWR baselines based on a repeating time schedule

C.
when computing statistics for all moving window baselines based on a repeating time schedule
in the future

D.
when resetting the threshold values for the SYSTEM_MOVING_WINDOW baseline based on a
repeating time schedule in the future



Leave a Reply 2

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


Carlos

Carlos

B)

You can also create baselines for a contiguous time period in the future using baseline templates. There are two types of baseline templates: single and repeating.

A single baseline template can be used to create a baseline for a single contiguous time period in the future. This is useful if you know beforehand of a time period that you want to capture in the future. For example, you may want to capture the AWR data during a system test that is scheduled for the upcoming weekend. In this case, you can create a single baseline template to automatically capture the time period when the test will take place.

A repeating baseline template can be used to create and drop baselines based on a repeating time schedule. This is useful if you want Oracle Database to automatically capture a contiguous time period on an ongoing basis. For example, you may want to capture the AWR data during every Monday morning for a month. In this case, you can create a repeating baseline template to automatically create baselines on a repeating schedule for every Monday, and automatically remove older baselines after a specified expiration interval such as one month.

L. Zhu

L. Zhu

AWR baseline template (repeating): create and drop baseline based on a repeating time schedule

B is right