ocp 052考試詳解：1Z0-V8.02-第47題，完整題庫(kù)請(qǐng)點(diǎn)擊這里聯(lián)系老師咨詢了解

47. Your database instance is functional for the past one month. The Automatic Workload Repository

(AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.

You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the

previous day.

Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

A.Use the Active Session History report.

B.Use the AWR Compare Periods report.

C.Use an ADDM analysis between 7 PM and 9 PM of the previous day.

D.Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.

Answer: BC

答案解析：

AWR 快照包括數(shù)據(jù)庫(kù)統(tǒng)計(jì)信息和度量、應(yīng)用程序統(tǒng)計(jì)信息(事務(wù)處理量和響應(yīng)時(shí)間)、操作系統(tǒng)統(tǒng)計(jì)信息及其它度量。AWR 基線是在一段時(shí)間內(nèi)收集的一組AWR 快照。基線用于性能比較，這既可以是當(dāng)前性能與基線的比較，也可以是一個(gè)基線與另一基線的比較。