EXA_USER_OBJECT_SIZES
Contains the size of all database objects owned by the current user. 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.
Column | Meaning |
---|---|
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
|
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 |