Oracle
1Z0-083 · Question #61
Which two are true about gathering optimizer statistics? (Choose two.)
The correct answer is B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT. https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/
Manage Database Performance
Question
Which two are true about gathering optimizer statistics? (Choose two.)
Options
- AExecuting DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers
- BExecuting DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in
- CExecuting DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT
- DExecuting DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers
- EExecuting DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers
How the community answered
(52 responses)- A6% (3)
- B83% (43)
- D10% (5)
- E2% (1)
Explanation
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/
Topics
#optimizer statistics#DBMS_STATS#CDB statistics#PDB statistics
Community Discussion
No community discussion yet for this question.