This system table lists the compressed and raw sizes of all columns in all user tables in all schemas owned by the current user. All users have access to this table.
| Column Name | Description |
|---|---|
COLUMN_SCHEMA
|
Associated schema |
COLUMN_TABLE
|
Associated table |
COLUMN_NAME
|
Name of column |
COLUMN_TYPE
|
Data type of column |
COLUMN_OWNER
|
Owner of the associated object |
COLUMN_OBJECT_ID
|
ID of the column |
COLUMN_ORDINAL_POSITION
|
Ordinal position of the column starting with 1 |
COLUMN_IS_VIRTUAL
|
Flag indicating whether the associated table is virtual |
RAW_OBJECT_SIZE
|
Uncompressed volume of data in the column in bytes (at last COMMIT) |
MEM_OBJECT_SIZE
|
Compressed volume of data in the column in bytes (at last COMMIT) |
