7.7.5.11 DESCRIBE GRIDDISK

Purpose

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

Syntax

DESCRIBE GRIDDISK

Usage Notes

The attributes for the DESCRIBE GRIDDISK command include the following:

• asmDeactivationOutcome: Indicator whether a grid disk can be deactivated without loss of data. A value of YES indicates the grid disk can be deactivated without data loss.

• asmDiskgroupName: Name of the Oracle ASM disk group.

• asmDiskName: Name of the Oracle ASM disk.

• asmDiskRepairTime: The amount of time the grid disk can remain offline before it is dropped by Oracle ASM.

• asmDiskSize: Size of the Oracle ASM disk.

  This attribute is available in Oracle Exadata System Software release 12.1.2.3.0 and later.

• asmFailGroupName: Name of the Oracle ASM failure group.

• asmModeStatus: Indicator shows the current Oracle ASM usage of a grid disk. Statuses are ONLINE, OFFLINE, DROPPED, UNUSED, SYNCING, or UNKNOWN.

• availableTo: Names of the clients that can access this grid disk.

• cachedBy: The name of the flash disks that are currently caching data for this grid disk for write-back flash cache.

• cachingPolicy: The flash caching policy for this grid disk. Values are default or none.

  • default means data for this grid disk uses the flash cache.

  • none means data for this grid disk do not use flash cache.

  The caching policy can be set when creating a grid disk, or using the ALTER GRIDDISK command.

• cellDisk: Name of the cell disk that contains the grid disk.

• comment: User-supplied text string.

• creationTime: Time stamp when the grid disk was created.

• diskType: The type of disk.

• errorCount: Count of hardware errors detected by the cell disk containing this grid disk.

• id: Global unique identifier (GUID) that is generated when the grid disk is created.

• name: Unique name of the grid disk.

• size: Total size of the grid disk.

• sizeAllocated: Total size of materialized space used by data in a sparse grid disk.

  This attribute is available in Oracle Exadata System Software 22.1.0 and later. It applies to sparse grid disks only.

• sparse: Whether the grid disk is a sparse disk.

• status: Current status of the grid disk, such as active, inactive, not present or importRequired.

• virtualSize: The size of the disk group for the sparse grid disks.

Note:

The asmDeactivationOutcome and asmModeStatus attributes must be explicitly specified when using the LIST GRIDDISK command.

Example 7-104 Describing the GRIDDISK Object

This example shows the DESCRIBE command with the GRIDDISK object.

CellCLI> DESCRIBE GRIDDISK

         name                      modifiable
         asmDeactivationOutcome    hidden
         asmDiskgroupName   
         asmDiskName
         asmDiskRepairTime         hidden
         asmDiskSize               hidden
         asmFailGroupName
         asmModeStatus             hidden
         availableTo               modifiable
         cachedBy
         cachingPolicy             modifiable
         cellDisk
         comment                   modifiable
         creationTime
         diskType
         errorCount
         id
         size                      modifiable
         sizeAllocated
         sparse
         status
         virtualSize               modifiable