Database Device Properties

Use the database device properties option 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. You can also modify the write option and increase the space for this device.

Click Properties on your database device to initiate the Properties wizard.

Wizard OptionDatabase Device 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, 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.
Related tasks
Creating a Database Device
Deleting a Database, In-Memory, or Dump Device
Generating a DDL Script