Oracle OCP 19c 认证1Z0-083考试(第22题)

最新推荐文章于 2024-01-22 22:00:00 发布

原创

最新推荐文章于 2024-01-22 22:00:00 发布 · 573 阅读

收录于

当前文章被以下社区和专栏收录：

关于收集Oracle优化器统计信息，正确的选项是B和C。在读写模式下连接到PDB时执行DBMS_STATS.GATHER_DATABASE_STATS将收集该PDB的对象统计信息；而在CDB$ROOT中执行则只收集CDB$ROOT的数据。D选项错误，系统统计信息可以在连接到CDB$ROOT时收集。E选项不正确，因为在CDB$ROOT中执行不会收集所有打开的PDB对象统计信息。

Which two are true about gathering optimizer statistics? (Choose two.)
A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
D. System statistics can be gathered only while connected to CDB$ROOT.
E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

BC: https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/

tested on 19c and 12.2 test provided by ald85 is not accurate, E is not corect try creating simple tales in ROOT and PDB than gather d

标签