V$CONTAINERS

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

• 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

• 1: This value is used for rows containing data that pertain to only the root

• n: Where n is the applicable container ID for the rows containing data

DBID

NUMBER

PDB identifier calculated when the PDB is created and stored in all file headers associated with the PDB

CON_UID

NUMBER

Unique identifier associated with the PDB

GUID

RAW(16)

Globally unique identifier (GUID) of this PDB

NAME

VARCHAR2(30)

Name of the PDB

OPEN_MODE

VARCHAR2(10)

Open mode information. Possible values:

• MOUNTED

• READ WRITE

• READ ONLY

• MIGRATE

RESTRICTED

VARCHAR2(3)

Indicates whether only users possessing RESTRICTED SESSION privilege can connect to the PDB

OPEN_TIME

TIMESTAMP(3)

Date and time when the database was last opened

CREATE_SCN

NUMBER

System change number (SCN) for the creation of this PDB

TOTAL_SIZE

NUMBER

If a PDB is opened, disk space (in bytes) used by the container, including both data and temp files. If a PDB is closed, will be set to 0.

BLOCK_SIZE

NUMBER

The current block size for the PDB

RECOVERY_STATUS¹

VARCHAR2(8)

Shows whether recovery is enabled or disabled for the PDB. Possible values:

• ENABLED

• DISABLED

SNAPSHOT_PARENT_CON_ID¹

NUMBER

This column shows the container ID of the master PDB that this PDB is a snapshot clone of. This column shows a non-zero value only if the PDB is a snapshot clone. For all other cases, it shows a value of 0.