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!
|