Segment space usage
(DBNAME, SEGNAME)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| TSYNC | long | Internal-use tsync; created by Surveillance
Note: This column may be removed in a future release.
|
| DBNAME | string(32) | Database name |
| SUSPECT | string(8) | Whether segment is suspect; * = suspect |
| SEGNAME | string(68) | Segment name |
| TOTALSIZEMB | double | Total allocated size, in megabytes |
| TOTALPAGES | double | Total allocated size, in pages |
| FREEPAGES | double | Unused space, in pages |
| USEDPAGES | double | Amount of space used, in pages |
| FREEMB | double | Unused space, in megabytes |
| USEDMB | double | Amount of space used, in megabytes |
| USEDPCT | double | % space used |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| USEDMB_DELTA | double | Delta amount of space used, in megabytes |
| USEDMB_DELTA_AVG | double | Average of delta amount of space used per interval, in megabytes, since collection started |
| TOTALSIZEB | double | Total allocated size, in bytes |
| FREEB | double | Unused space, in bytes |
| USEDB | double | Amount of space used, in bytes |
| USEDB_DELTA | double | Delta amount of space used, in bytes |
| USEDB_DELTA_AVG | double | Average of delta amount of space used per interval, in bytes, since collection started |
| Attributes: | None |
|---|---|
| Minimum database version: | 12.5.0.3 |