7.7.5.6 DESCRIBE DATABASE

Purpose

Displays the specified attributes for active databases.

Syntax

DESCRIBE DATABASE

Usage Notes

The attributes for the DESCRIBE DATABASE command include the following:

• name: The database name.

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

• databaseID: The unique identifier for the database.

• flashCacheLimit: Specifies the amount of flash cache space that is available to the database. The value is a soft limit, so the database 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 database.

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

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

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

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

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

• lastRequestTime: The time stamp of the last request from the database.

• pmemCacheLimit: Specifies the amount of PMEM cache space that is available to the database. The value is a soft limit, so the database 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 database.

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

• profile: The IORM profile associated with the database.

• xrmemCacheLimit: Specifies the amount of XRMEM cache space that is available to the database. The value is a soft limit, so the database 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 database.

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

Examples

The following example shows the DESCRIBE command with the DATABASE object.

Example 7-98 Describing the DATABASE Object

CellCLI> DESCRIBE DATABASE
        name
        asmClusterName
        databaseID
        flashCacheLimit
        flashCacheMin
        flashCacheSize
        iormDiskLimit
        iormDiskShare
        iormFlashLimit
        iormFlashShare
        lastRequestTime
        pmemCacheLimit
        pmemCacheMin
        pmemCacheSize
        profile
        xrmemCacheLimit
        xrmemCacheMin
        xrmemCacheSize