Device space usage
(INSTANCEID, DEVICE)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| DEVICE | string(32) | Device name |
| DEVTYPE | string(32) | Device type (default disk, physical disk, archive database disk, other) |
| SIZEMB | double | Total allocated size (at the OS level), in megabytes |
| ALLOCMB | double | Amount of used space (USEDMB) that is allocated to database objects, in megabytes |
| UNALLOCMB | double | Amount of used space (USEDMB) that is unused by database objects, in megabytes |
| USEDMB | double | Amount of space used, in megabytes |
| FREEMB | double | Unused space, in megabytes |
| DEVSTATUS | string(256) | Options and attributes of the device |
| PHYNAME | string(128) | Physical name (path) of the device |
| PCTALLOC | double | % of used space (USEDMB) that is allocated to database objects |
| PCTUSED | double | % of total allocated size (at the OS level) that is used |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| SIZEB | double | Total allocated size (at the OS level), in bytes |
| ALLOCB | double | Amount of used space (USEDB) that is allocated to database objects, in bytes |
| UNALLOCB | double | Amount of used space (USEDB) that is unused by database objects, in bytes |
| USEDB | double | Amount of space used, in bytes |
| FREEB | double | Unused space, in bytes |
| Attributes: | None |
|---|---|
| Minimum database version: | 12.5.0.3 |