Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

The correct answer is A. ADDM can run in a nonroot container. B. AWR snapshots can be created in CDB$ROOT. E. AWR snapshots can be created in a PDB. The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root. The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB. Starting with Oracle Database 12c, ADDM is enabled by default in the root container of a multitenant container database (CDB)…

Monitoring and Tuning

Question

Options

AADDM can run in a nonroot container.
BAWR snapshots can be created in CDB$ROOT.
CAWR reports can be generated while connected to any container.
DAll AWR data is stored in the CDB$ROOT SYSAUX tablespace.
EAWR snapshots can be created in a PDB.
FNo AWR data is stored in the CDB$ROOT SYSAUX tablespace.

How the community answered

(51 responses)

A
82% (42)
C
10% (5)
D
2% (1)
F
6% (3)

Explanation

The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root. The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB. Starting with Oracle Database 12c, ADDM is enabled by default in the root container of a multitenant container database (CDB). Starting with Oracle Database 19c, you can also use ADDM in a pluggable database (PDB).

Topics

#AWR snapshots#ADDM#multitenant monitoring#SYSAUX tablespace

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice