7.136 V$CONTAINERS

V$CONTAINERS displays information about PDBs and the root associated with the current instance.

Column Datatype Description

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(128)

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 nonzero value only if the PDB is a snapshot clone. For all other cases, it shows a value of 0.

APPLICATION_ROOT

VARCHAR2(3)

Indicates whether the PDB is an application root

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

APPLICATION_PDB

VARCHAR2(3)

Indicates whether the PDB is an application PDB

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

APPLICATION_SEED

VARCHAR2(3)

Indicates whether the PDB is an application seed (an application seed is also an application PDB)

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

APPLICATION_ROOT_CON_ID

NUMBER

If this PDB is an application PDB, the container ID of an application root to which this application PDB belongs.

If this PDB is an application root clone, the container ID of an application root to which this application root clone belongs.

Otherwise, NULL.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

APPLICATION_ROOT_CLONE

VARCHAR2(3)

Indicates whether this PDB is an application root clone (YES) or not (NO)

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

PROXY_PDB

VARCHAR2(3)

Indicates whether this PDB is a proxy PDB (YES) or not (NO)

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

LOCAL_UNDO

NUMBER

Shows whether the PDB is in local undo. Possible values:

  • 1 – PDB is in local undo mode

  • 0 – PDB is in shared undo mode

This column is not relevant for CDB$ROOT.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

UNDO_SCN

NUMBER

System change number (SCN) at which the PDB was last converted from shared to local undo, or from local to shared undo.

This column is not relevant for CDB$ROOT.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

UNDO_TIMESTAMP

DATE

Date and time at which the PDB was last converted from shared to local undo, or from local to shared undo. 

This column is not relevant for CDB$ROOT.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

CREATION_TIME

DATE

Date and time at which the PDB was created.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

PDB_COUNT

NUMBER

The number of user-created PDBs belonging to a given application root or CDB$ROOT. For all other containers, its value is 0.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

AUDIT_FILES_SIZE

NUMBER

Shows the current disk space usage (in bytes) by Unified Audit files (.bin format) in the container

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

MAX_SIZE

NUMBER

Shows the maximum amount of disk space (in bytes) that can be used by data and temp files in the container

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

MAX_DIAGNOSTICS_SIZE

NUMBER

Shows the maximum amount of disk space (in bytes) that can be used by diagnostic traces generated in the container

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

MAX_AUDIT_SIZE

NUMBER

Shows the maximum amount of disk space (in bytes) that can be used by Unified Audit files (.bin format) in the container

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).