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 |