Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Oracle 12c New Features

Online Oracle Training


How to change instance parameters which may impact on PDBs


On the multitenant architecture, you may change some parameters that will impact only pluggable databases.


To list all parameters that will impact at the pluggable databases.

SQL> SELECT ispdb_modifiable FROM v$parameter

   2   WHERE ispdb_modifiable= "YES";


To change them, you need login to the pluggable database using your net service name created in the tnsnames.ora file.


For example:

# sqlplus /nolog

At the root container

SQL> CONNECT / as sysdba


At the pluggable level

SQL> CONNECT sys/mypass@mypdb1 as sysdba


The optimizer_use_sql_plan_baselines parameter is a parameter that can be modified in the root container or other pluggable databases.


To check the instance value for the optimizer_use_sql_plan_baselines parameter in root and PDBs

SQL> SELECT con_id, value FROM v$system_parameter

   2   WHERE name=" optimizer_use_sql_plan_baselines";


To change it, just go to that pluggable database and set the value.

SQL> CONNECT sys/mypass@mypdb1 as sysdba

SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines = FALSE SCOPE=BOTH;

System altered.


You can use show parameter to see the value.

SQL> show parameter optimizer_use_sql_plan_baselines


Notice that the output will be different depending where you are. If you are in the root container, the output will be different than when you are in a pluggable database.


Good Luck!



Web web site