Tablespace usage
(NAME)
| Name | Data Type | Description |
|---|---|---|
| TS# | long | Tablespace ID |
| NAME | string(32) | Tablespace name |
| BLOCKSIZE | double | Block size for the tablespace |
| STATUS | string(12) | Tablespace status (ONLINE, OFFLINE, READ ONLY) |
| CONTENTS | string(8) | Tablespace contents (UNDO, PERMANENT, TEMPORARY) |
| LOGGING | string(4) | Default logging attribute for objects in the tablespace |
| EXTENT_MANAGEMENT | string(12) | Extent management type (DICTIONARY, LOCAL) |
| TOTAL_BLOCKS | double | Total allocated size of the tablespace, in blocks |
| TOTAL_BYTES | double | Total allocated size of the tablespace, in bytes |
| TOTAL_MBYTES | double | Total allocated size of the tablespace, in megabytes |
| FREE_SEGMENTS | long | Number of free space segments (which are each continuous) |
| FREE_BLOCKS | double | Unused space, in blocks |
| FREE_MBYTES | double | Unused space, in megabytes |
| LARGEST_SEGMENT_BLOCKS | double | Largest continuous free space segment, in blocks |
| LARGEST_SEGMENT_MBYTES | double | Largest continuous free space segment, in megabytes |
| PCT_USED | double | % of total allocated size that is used |
| PCT_USED_AUTO | double | % of total autoextend size that is used |
| AUTOEXTENSIBLE | string(4) | Whether the tablespace files are autoextensible |
| Attributes: | None |
|---|---|
| Minimum database version: | 8.1 |