Check parameter modified in PDB database in Oracle

List the parameter which modified in PDB database.

Set the container or PDB:

ALTER SESSION SET CONTAINER=pdbname;

Check the list of parameter which able to modified for PDB database:

SELECT NAME FROM V$SYSTEM_PARAMETER WHERE ISPDB_MODIFIABLE = ‘TRUE’
 ORDER BY NAME;

Change the value of parameter for PDB database:

-- Check the con_name
SHOW CON_NAME
-- Alter the PGA target only at current PDB which show with above command
ALTER SYSTEM SET PGA_AGGREGATE_TARGET=10G SCOPE = SPFILE;

Check the value of all PDB or CDB parameters:

SELECT NAME, VALUE, DISPLAY_VALUE, CON_ID FROM V$SYSTEM_PARAMETER
 WHERE NAME = 'PGA_AGGREGATE_TARGET' ORDER BY NAME;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply