iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

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

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 12c New Features

Online Oracle Training

LESSON 14

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!

 

 

Google
 
Web web site