Provides information about the file systems on which database devices are allocated. Space information is available only for file system devices. File system size and free space values are NULL for database devices allocated on raw devices.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns in monDeviceSpaceUsage are:
Name |
Datatype |
Description |
|---|---|---|
InstanceID |
tinyint |
(Cluster environments only) ID of the instance |
VDevNo |
int |
Virtual number of the device |
LogicalName |
varchar(30) |
Logical name of the device |
PhysicalName |
varchar(128) |
Physical name of the device |
DeviceSizeMB |
int |
Size of the device, in megabytes |
FileSystemName |
varchar(128) |
Name of the file system |
FileSystemSizeMB |
int |
Size of the file system, in megabytes |
FileSystemFreeMB |
int |
Amount of available free space, in megabytes, on the file system |
