Instance parameters changes on Pluggable Database

                 In this example, I am going to show you some of the parameters can be changed in a pluggable database, if the impact is limited to the current container.  However, the global parameters like SGA_TARGET can be set only through root container – CDB$ROOT. A new column ISPDB_MODIFIABLE is added  in V$PARAMETER view to list the parameters modifiable from a PDB.

Lab :-

                        Container Database : CDB1

                        Pluggable Database : PDB1

Overview:

1.     Log into CDB1 as sys

2.     Check the current value of instance parameter optimizer_use_sql_plan_baselines'.

3.     Log into PDB1 as sys

4.     Check the current value of instance parameter 'optimizer_use_sql_plan_baselines'.

5.     Change the Instance parameter value to FALSE in PDB1

6.     Check the instance parameter value changes

Task 1:- Log into CDB1 as sys

Task 2:- Check the current value of instance parameter 'optimizer_use_sql_plan_baselines'

Task 3:- Log into PDB1 as sys

Task 4:- Check the current value of instance parameter 'optimizer_use_sql_plan_baselines'

Task 5:- Change the Instance parameter value to FALSE in PDB1

To check the parameter value at CDB .

Another Method:-

To change PDB1 instance parameter value through CDB1 database  .

To check the parameter value at PDB

Hope it helps. Please stay tuned, add me to your G+ Circles!! Your feedback always helps me and motivates me to blog more, please leave your valuable comment that is always a pleasure to read.

Many Thanks,

Regards

Senthilkumar Devaraj