← PDB & Multitenant
Oracle · PDB & Multitenant

How to check PDB saved state in Oracle Multitenant

Check which PDBs have a saved open state, so they reopen automatically when the CDB restarts, from DBA_PDB_SAVED_STATES.

Tested on12c18c19c21c23ai26ai

Check which PDBs have a saved open state, so they reopen automatically when the CDB restarts instead of staying mounted.

SELECT con_name, instance_name, state
FROM   dba_pdb_saved_states
ORDER  BY con_name;
PDBMultitenantSaved State