7.7.5.21 DESCRIBE PLUGGABLEDATABASE

Purpose

The DESCRIBE PLUGGABLEDATABASE command displays a list of attributes for the PLUGGABLEDATABASE object type.

Syntax

DESCRIBE PLUGGABLEDATABASE

Usage Notes

The attributes for the DESCRIBE PLUGGABLEDATABASE command can include the following:

  • asmClusterName: The Oracle ASM cluster name or alias. Available with Oracle Exadata System Software release 19.1.0 or later.

  • flashCacheLimit: The specified limit on the Flash cache for this pluggable database (PDB)

  • flashCacheMin: The specified minimum size of the Flash cache for this PDB

  • flashCacheSize: The size of the Flash cache specified for this PDB

  • iormLimit: The disk I/O utilization limit for the PDB. Available with Oracle Exadata System Software release 19.1.0 or later.

  • iormShare: The IORM share number for the PDB. Available with Oracle Exadata System Software release 19.1.0 or later.

  • name: The name of the PDB

  • pdbID: The ID for the PDB

  • pmemCacheLimit: The specified limit on the PMEM cache for this pluggable database (PDB)

  • pmemCacheMin: The specified minimum size of the PMEM cache for this PDB

  • pmemCacheSize: The size of the PMEM cache specified for this PDB

  • name: The pluggable database (PDB) name.

  • asmClusterName: The name of the associated ASM cluster. This attribute is populated when ASM-scoped security is configured.

  • containerName: The name of the container database (CDB)

  • flashCacheLimit: Specifies the amount of flash cache space that is available to the PDB. The value is a soft limit, so the PDB may consume more space if the flash cache is not full.

  • flashCacheMin: Specifies the minimum amount of flash cache space that is guaranteed for the PDB.

  • flashCacheSize: Specifies the maximum amount of flash cache space that is available to the PDB. The value is a hard limit that cannot be exceeded at any time.

  • iormDiskLimit: Specifies the I/O utilization limit for the PDB, expressed as a percentage of the available disk resources.

  • iormFlashLimit: Specifies the I/O utilization limit for the PDB, expressed as a percentage of the available flash resources.

  • iormShare: Specifies the relative share of I/O resources that is available to the PDB. A higher share value implies higher priority and more access to the I/O resources.

  • pdbID: The unique identifier for the PDB.

  • pmemCacheLimit: Specifies the amount of PMEM cache space that is available to the PDB. The value is a soft limit, so the PDB may consume more space if the PMEM cache is not full.

  • pmemCacheMin: Specifies the minimum amount of PMEM cache space that is guaranteed for the PDB.

  • pmemCacheSize: Specifies the maximum amount of PMEM cache space that is available to the PDB. The value is a hard limit that cannot be exceeded at any time.

  • xrmemCacheLimit: Specifies the amount of XRMEM cache space that is available to the PDB. The value is a soft limit, so the PDB may consume more space if the XRMEM cache is not full.

  • xrmemCacheMin: Specifies the minimum amount of XRMEM cache space that is guaranteed for the PDB.

  • xrmemCacheSize: Specifies the maximum amount of XRMEM cache space that is available to the PDB. The value is a hard limit that cannot be exceeded at any time.

Example 7-113 Describing the PLUGGABLEDATABASE Object

CellCLI> DESCRIBE PLUGGABLEDATABASE
        name
        asmClusterName
        containerName
        flashCacheLimit
        flashCacheMin
        flashCacheSize
        iormDiskLimit
        iormFlashLimit
        iormShare
        pdbID
        pmemCacheLimit
        pmemCacheMin
        pmemCacheSize
        xrmemCacheLimit
        xrmemCacheMin
        xrmemCacheSize

Parent topic: DESCRIBE