1Z0-067 · Question #25
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; Which two statements are true about the…
The correct answer is A. It is immediately set to all in the SPFILE and the CDB instance. D. It is immediately set to all in all PDBs where the statistics_level parameter is not set. When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the…
Question
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; Which two statements are true about the statistics level parameter?
Options
- AIt is immediately set to all in the SPFILE and the CDB instance.
- BIt is immediately set to all in only those pluggable databases (PDBs) where the value is set to
- CIt is immediately set to all only for cd3Sroot.
- DIt is immediately set to all in all PDBs where the statistics_level parameter is not set.
- EIt is set to all for all PDBs only in the SPFILE.
How the community answered
(28 responses)- A82% (23)
- B11% (3)
- C4% (1)
- E4% (1)
Explanation
When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the local session only. Their system-wide state is not changed.
Topics
Community Discussion
No community discussion yet for this question.