Oracle
1Z0-054 · Question #8
A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showing poor performance and completing at 2 AM. To help in the diagnosis of the…
The correct answer is B. It compares details between any two selected time periods of the same duration. C. It normalizes the statistics by the amount of time spent on the database for each time period. See the full explanation below for the reasoning.
Question
A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showing poor performance and completing at 2 AM. To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to execute the awrddrpt.sql script to produce a Compare Periods report. Which two statements are true about the report produced by this script? (Choose two.)
Options
- AIt is refreshed automatically based on the moving window baseline.
- BIt compares details between any two selected time periods of the same duration.
- CIt normalizes the statistics by the amount of time spent on the database for each time period.
- DIt compares details between two consecutive time periods of the same or different durations and
How the community answered
(30 responses)- A13% (4)
- B80% (24)
- D7% (2)
Community Discussion
No community discussion yet for this question.