QUESTION 15-SGA Monitoring

QUESTION 15
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.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
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 and control information for a single process.

 

问题15

在包含可插入数据库(PDB)的多租户容器数据库(CDB)中，用户抱怨性能下降。

实时自动数据库诊断监视器(ADDM)如何检查性能下降并提供解决方案?

a .它从SGA中收集数据，并与保留的快照进行比较。

B.从SGA收集数据，分析数据，并提供报告。

C.从SGA收集数据，并与最新的快照进行比较。

D.它从SGA和PGA收集数据，分析数据，并提供报告。

正确答案是:B

部分:(一)

解释

解释/参考:

解释:

注意:

多租户架构使得Oracle数据库可以像一个多租户容器数据库(CDB)一样，包含0个、1个或多个客户创建的可插拔数据库(pdb)。PDB是模式、模式对象和非模式对象的可移植集合，在Oracle Net客户机上以非cdb的形式出现。Oracle Database 12c之前的所有Oracle数据库都是非cdbs。

System Global Area (SGA)是一组共享内存区域，专门用于Oracle的实例(实例是你的数据库程序和RAM)。

PGA(程序或进程全局区域)是一个存储单个进程数据和控制信息的内存区域(RAM)。