You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*’ SCOPE = SPFILE;
Which is true about the result of this command?
A.
The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
B.
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
C.
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is
restarted.
D.
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
Explanation:
Note:
* In a container architecture, the parameters for PDB will inherit from the root database. That means if
statistics_level=all in the root that will cascade to the PDB databases.
You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column
in v$system_parameter for the same.