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 non-CDB. 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 andcontrol information for a single process.
Also not agree!
An ADDM analysis can be performed on a pair of AWR snapshots and a set of instances from the same database. The pair of AWR snapshots define the time period for analysis, and the set of instances define the target for analysis.
An ADDM analysis is performed each time an AWR snapshot is taken and the results are saved in the database. The time period analyzed by ADDM is defined by the last two snapshots (the last hour by default).
Me for C! Any idea?
12 c new feature REAL-TIME ADDM NOT ADDM SO B
Yes I m with noori Correct Answer is A
Sorry B
D
B
Real-Time ADDM access just the ASH recent activity from the SGA. It doesn’t compare snapshots.
Real-Time is meant to be used if a instance is hung and will give you information that is store in memory. Snapshot data may not be available.
B
real time ADDM means only use information from SGA, not anything in AWR as it may not be accesible.
B