Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter?

Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.Examine the commands to change the value of the PDB modifiable initialization parameter:$> sqlplus sys/[email protected] AS SYSDBASQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH;SQL> CONN sys/[email protected] AS SYSDBASQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;SQL> CONN sys/[email protected] AS SYSDBASQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter? (Choose the best answer.)Reference: https://oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1

Question:

Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter?

Options:

It gives an error because it cannot be set for the root database.

It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PD

It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.

It is set to TRUE for the root database and all the PDBs, but is effective only when CDB is restarted and the PDBs are reopened.

Correct Answer

The Correct Answer for this Question is

It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PD

You may also like...

Leave a Reply

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