Database Device Properties

Use the database device properties window to view the device's general information, as well as analyze its mirror status, databases that occupy the space on the device, and segments contained in the device.

Click the Name field of the database device, then click the drop-down arrow and select Properties.

Pages Properties
General
  • Name and type of device
  • I/O fencing support (cluster environment only)
  • Instance name (cluster environment only)
  • Physical name and path
  • Space allocated – you can change the value, which is in megabytes.
  • Default device – specify whether to set this device as the default device.
  • Write option – choose data sync, direct I/O, or cached I/O (data sync off) for this device.
Mirror Displays whether disk mirroring is enabled. If it is, you can select:
  • Mirror device – turn on mirror device, choose whether the mirror is written after the primary is written or in parallel with parallel writes, and specify the mirror path in a file name relative to the server.
  • Disable mirror – select either the primary or secondary device to disable, and whether this disabling is temporary or permanent.
Databases Displays a list of databases that occupy space on the device. Click Properties to see the database properties without going to the Database view.
Segments Displays a list of segments contained in the device. Click Properties to view segment properties without going into the segment view.