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

?

?

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 db stats from ROOT, and you will see that PDB tables stats will not be gathered.

https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html#GUID-B930CE9B-7461-4691-8AA9-7E424C3C2C8C

?

?

?