Purpose

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

Syntax

DESCRIBE PHYSICALDISK

Usage Notes

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

• ctrlFirmware: The hard disk controller software version

• ctrlHwVersion: The hard disk controller hardware version

• deviceID: The ID for the physical disk

• deviceName: The name of the physical disk device, for example /dev/sdx

• diskType: Type of the disk, whether it is a HardDisk, FlashDisk, or M2Disk.

• enclosureDeviceId: Identifier for the hard disk enclosure. This attribute is only applicable to Oracle Exadata System Software on Oracle Exadata Storage Server.

• errCmdTimeoutCount: The count of execution of commands related to physical disks that timed out, for example, disk firmware upgrade, listing physical disks, and so on.

• errHardReadCount: Total count of read errors on a physical disk

• errHardWriteCount: Total count of write errors on a physical disk

• errorCount: The sum of all known error counts for a physical disk

• errOtherCount: Total error count of all other (unknown) errors for a physical disk

• errSeekCount: Total number of disk seek errors

• flashLifeLeft: The percentage of flash disk life left for a disk

• hotPlugCount: Total number of times a disk has been pulled out and reinserted (hot plugged)

• lastFailureReason: The reason for the last physical disk failure

• luns: List of LUNs converted from this disk. M.2 disks do not have LUNs.

• makeModel: Model description provided by the system

• name: Unique name of the physical disk

• notPresentSince: Date at which the disk was no longer detected

• physicalFirmware: The version of the firmware

• physicalInsertTime: Time that the disk was inserted

• physicalInterface: Interface type used by the hard disk. For example, SAS

• physicalPort: (Only appplicable for HP models) The physical disk port value

• physicalRPM: The RPM value of a physical hard disk. This attribute is also used to determine the disk type (SATA or SAS).

• physicalSerial: System-assigned unique ID

• physicalSize: Size of the disk in bytes

• physicalUseType: Intended use of the disk, for example, Data Drive

• sectorRemapCount: Total number of physical disk sectors that have been remapped because of sector failures

• slotNumber: Physical location of disk. This attribute is only applicable to Oracle Exadata System Software on Oracle Exadata Storage Server.

• status: Status of the physical disk. Values can be:

  • failed: The disk has failed. In earlier releases, this status was called critical.

  • normal: The disk is functioning normally

  • not present: The disk has been removed

  • peer failure: Flash disk failure only

  • poor performance: The disk is performing poorly

  • predictive failure: The disk is expected to fail

  • write-through caching: Flash disk caching only.