You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight. How would you achieve this? (Choose the best answer.)
A.
Create AWR baselines.
B.
Create SQL plan baselines.
C.
Create repeating baseline templates.
D.
Create database services and make sure that user connections use them to connect to the database instance.
Correct Ans: C
Baseline Templates
Baseline templates enable you to create baselines for a contiguous time period in the future. There are two types of baseline templates:
Single Baseline Templates
Use a single baseline template 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 intend to capture in the future. For example, you may want to capture 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 occurs.
Repeating Baseline Templates
Use a repeating baseline template 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 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.
upvoted 3 times
...
This section is not available anymore. Please use the main Exam Page.1z0-064 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Jatindra
4 years, 11 months ago