EXA_DBA_COLUMN_SIZES

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)