EXA_ALL_OBJECT_SIZES

This system table contains the sizes of all of the database objects to which the current user has access. 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 therein. All users have access to the table.

Column Name Description
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object
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 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