nerdexam
Oracle

1Z0-060 · Question #3

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…

The correct answer is B. It collects data from SGA, analyzes it, and provides a report. 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…

New Features for Performance

Question

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?

Options

  • AIt collects data from SGA and compares it with a preserved snapshot.
  • BIt collects data from SGA, analyzes it, and provides a report.
  • CIt collects data from SGA and compares it with the latest snapshot.
  • DIt collects data from both SGA and PGA, analyzes it, and provides a report.

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    89% (24)
  • C
    4% (1)

Explanation

*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 *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.

Topics

#real-time ADDM#SGA data collection#CDB performance#ADDM report

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice