Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?
(Choose three.)
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?
(Choose three.)
In an Oracle multitenant environment, ADDM can run in a nonroot container, such as a pluggable database (PDB). This functionality became available starting with Oracle Database 19c, which allows ADDM to be used in both root and nonroot containers. AWR snapshots can be created in the CDB$ROOT container, allowing for system-wide performance data collection. Additionally, AWR snapshots can also be created at the PDB level, enabling specific performance data collection for individual pluggable databases. All AWR data, however, is not exclusively stored in the CDB$ROOT SYSAUX tablespace but rather in the respective SYSAUX tablespaces of the containers or PDBs where the snapshots were taken.
ABE correct 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).
A and B are correct no doubt, E is also correct: SQL> show con_name CON_NAME ------------------------------ PDB1 SQL> EXECUTE dbms_workload_repository.create_snapshot(); PL/SQL procedure successfully completed.
a little tricky: AWR data IS stored in SYSAUX, but it is stored on a per-container/PDB basis.
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-performance-diagnostics.html#GUID-B4B0899D-90A3-4E19-8654-1D5C34A48FD5
I would go with ABE. It is confusing, however. AWR reports can run in pluggables; therefore, I assume C is incorrect because AWR reports cannot run in pdb$seed - which would (by extension) make A incorrect as well. SQL> alter pluggable database close; SQL> alter pluggable database open; SQL> show con_name CON_NAME ------------------------------ PDB$SEED SQL> EXEC dbms_workload_repository.create_snapshot() BEGIN dbms_workload_repository.create_snapshot(); END; * ERROR at line 1: ORA-13518: Invalid database id (0) ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99 ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 145 ORA-06512: at line 1
useful query select * from v$sysaux_occupants;
but F is correct as well, the SYSAUX tablespace has another schemas data apart from AWR F. No AWR data is stored in the CDB$ROOT SYSAUX tablespaspce
I think ABE https://oracledbwr.com/oracle-19c-addm-support-for-pdb-database/ https://asanga-pradeep.blogspot.com/2017/06/enabling-automatic-awr-snapshots-on-pdb.html