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 |