Oracle 1z0-083 Question Answer
Choose two. Which two are true about gathering optimizer statistics?
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).
System statistics can be gathered only while the CDB is in MOUNT state.
Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.
TESTED 13 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved