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 |