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-114 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