9.7.3.9 DESCRIBE PHYSICALDISK

Purpose

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

Syntax

DESCRIBE PHYSICALDISK

Usage Notes

The following table lists the attributes for the DESCRIBE PHYSICALDISK command.

Table 9-10 DESCRIBE PHYSICALDISK Attributes

Attribute	Description
ctrlHwVersion	Controller version. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
diskType	Type of the disk, whether it is a HARDDISK or a FLASHDISK.
enclosureDeviceId	Identifier for the hard disk enclosure. This attribute is only applicable to Oracle Exadata System Software on Oracle Exadata Storage Server.
errCmdTimeoutCount	Count of the number of command timeout SCSI errors on the disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
errHardReadCount	Count of the number of hard read errors on the disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
errHardWriteCount	Count of the number of hard write errors on the disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
errMediaCount	Count of the number of media errors on the hard disk. This attribute is only applicable to Oracle Exadata System Software on Oracle Exadata Storage Server.
errOtherCount	Count of unclassified errors on the hard disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
errSeekCount	Count of the number of SCSI seek errors on the disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
hotPlugCount	Count of the times the disk has been inserted into the rack. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
lastFailureReason	Type of the most-recent error on the disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
luns	List of LUNs converted from this disk.
makeModel	Model description provided by the system.
name	Unique name of the physical disk.
physicalFirmware	System-assigned name of the firmware for the disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
physicalInsertTime	Time that the disk was inserted.
physicalInterface	Interface type used by the hard disk. For example, SAS
physicalPort	Port on the controller for this disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
physicalRPM	Disk revolutions per minute. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
physicalSerial	System-assigned unique ID.
physicalSize	Size of the disk in bytes.
physicalUseType	Intended use of the disk. For example, Data Drive.
sectorRemapCount	Count of all sector remap operations for the physical disk. This attribute is only applicable to Oracle Exadata System Software on HP Oracle Database Machine.
slotNumber	Physical location of disk.
status	Status of the physical disk. Values can be as follows: failed: disk has failed. In earlier releases, this status was called critical. normal: disk is functioning normally not present: disk has been removed peer failure: flash disk failure only poor performance: disk is performing poorly predictive failure: disk is expected to fail write-through caching: flash disk caching only.

Example 9-45 Describing the PHYSICALDISK Object on a Hard Drive in a Database Server

This example shows the DESCRIBE command with the PHYSICALDISK object on Oracle Exadata Storage Server.

DBMCLI> DESCRIBE PHYSICALDISK

         name
         ctrlFirmware
         diskType
         enclosureDeviceId
         errMediaCount
         errOtherCount
         luns
         makeModel
         physicalFirmware
         physicalInsertTime
         physicalInterface
         physicalSerial
         physicalSize
         slotNumber
         status