In Oracle 12c multitenant databases CDB and PDBs use initialization parameters to control their behavior. Initialization Parameters for CDB and PDB have the following characteristics:
- CDB will have one SPFILE.
- PDB does not have an SPFILE.
- PDB inherit initialization parameters from their CDB.
- Most initialization parameters can be changed at the PDB level, these parameters that can have a value of TRUE in the column ISPDB_MODIFIABLE column of V$SYSTEM_PARAMETER view.
- Changing initialization parameters use the ALTER SYSTEM command with scope of SPFILE or BOTH and they survive system reboot.
Larry Catt
OCP