EXA_DBA_OBJECT_SIZES

This system table contains the sizes of all database objects. The values are calculated recursively, that is, the size of a schema includes the total of all of the sizes of the schema objects contained within. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
RAW_OBJECT_SIZE Uncompressed volume of data in the object in bytes (at last COMMIT)
MEM_OBJECT_SIZE Compressed volume of data in the object in bytes (at last COMMIT)
RAW_OBJECT_SIZE_LIMIT Upper limit for the uncompressed volume of data in the object in bytes
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID Unique ID of the object
OBJECT_IS_VIRTUAL States whether this is a virtual object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object