1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_PDB_SAVED_STATES

5.237 DBA_PDB_SAVED_STATES

DBA_PDB_SAVED_STATES shows information about the current saved PDB states in the CDB.

This view is a data link, so the data is also available within the PDB.

Column Datatype NULL Description

CON_ID

NUMBER

NOT NULL

The ID of the PDB

CON_NAME

VARCHAR2(128)

NOT NULL

Name of the PDB

INSTANCE_NAME

VARCHAR2(128)

NOT NULL

Name of the instance for which the state is saved

CON_UID

NUMBER

NOT NULL

Unique ID assigned to the PDB at creation time

GUID

RAW(16)

Globally unique immutable ID assigned to the PDB at creation time

STATE

VARCHAR2(14)

Open state of the PDB

RESTRICTED

VARCHAR2(3)

Restricted mode of the PDB

See Also:

Oracle Database SQL Language Reference for more information about preserving a PDB's open mode across an instance restart