Tblspace tblspace entries
The tblspace tblspace describes the characteristics of tblspaces.
To display information on a tblspace, use the oncheck
-pt command.
| Component | Description |
|---|---|
| Page header | 48 bytes of page-header information |
| Page-ending time stamp | 8 bytes |
| Tblspace header | 160 bytes, general tblspace information |
| Tblspace name | database.owner.tablename or
database.owner.indexname
Typically 30-40 bytes long but can be longer, depending on the length of the name. |
| Column information | 8 bytes for each special column A special column is defined as a VARCHAR, BYTE, TEXT, or user-defined data type. |
| Index information | A 20-byte header that contains general information about the index, followed by a 16-byte entry for each column in the index. |
| Extent information | An 18-byte entry plus 18 bytes of information for each extent that is allocated
to the tblspace. During the defragmentation of the tblspace, more bytes might be used. |