Which is true about the result of this command?

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?

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.



Leave a Reply 10

Your email address will not be published. Required fields are marked *


Sayed

Sayed

I tried this scenario correct Answer is A

noori

noori

Yes,test SAYED you are right!

Faryad Hussain

Faryad Hussain

Correct Answer is A, I have also tested it

H*T*H

H*T*H

The given answer, C is wrong because it is not the only true statement. Changing a parameter and specifying SCOPE=SPFILE means that change will not take effect until the instance/database is re-started. If the CDB is re-started then that will close and MOUNT all the PDBs. When the PDB in question is re-opened, its STATISTICS_LEVEL will have changed. So C is a true statement. However, closing and re-opening the PDB in question will have the same effect, i.e. when it re-opens its STATISTICS_LEVEL will have changed. So A is also true. Hence, C is not the only true statement.

H*T*H

Sylvain

Sylvain

A,C are right.
A cause Parameters are when PDB is closed.
C because spfile will do its job

Alexis

Alexis

R= A

SQL> ALTER SESSION SET CONTAINER = db12cp;

Session altered.

SQL> ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;

System altered.

SQL> show parameters STATISTICS_LEVEL

NAME TYPE VALUE
———————————— ———– ——————————
statistics_level string TYPICAL

SQL> startup force
Pluggable Database opened.

SQL> show parameters STATISTICS_LEVEL

NAME TYPE VALUE
———————————— ———– ——————————
statistics_level string ALL
SQL> sho con_id

CON_ID
——————————
3

SQL> select con_id,name,open_mode from v$pdbs;

CON_ID NAME OPEN_MODE
———- —————————— ———-
3 DB12CP READ WRITE

click through the following page

click through the following page

Hello there, You have done an incredible job. I will definitely digg it and personally suggest to my friends. I’m confident they’ll be benefited from this site.|

Amit

Amit

Correct answer is A.