This system table lists the compressed and raw sizes of all columns in all user tables in all schemas. Only users with SELECT ANY DICTIONARY privilege have access to the 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) |