In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about
performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and
provide solutions?
A.
It collects data from SGA and compares it with a preserved snapshot.
B.
It collects data from SGA, analyzes it, and provides a report.
C.
It collects data from SGA and compares it with the latest snapshot.
D.
It collects data from both SGA and PGA, analyzes it, and provides a report.
Explanation:
Note:
* The multitenant architecture enables an Oracle database to function as a multitenant container database
(CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable
collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a nonCDB. All Oracle databases before Oracle Database 12c were non-CDBs.* The System Global Area (SGA) is a group of shared memory areas that are dedicated to an Oracle instance
(an instance is your database programs and RAM).
* The PGA (Program or Process Global Area) is a memory area (RAM) that stores data and control information
for a single process.