EXA_OBJECTSTORAGE_USAGE

The system table shows details of the database usage of the cloud storage volumes. All users have access to the table.

Column Name Description
CLUSTER_ID The identifier of the cluster.
TABLESPACE The tablespace of the volume
IPROC Number of the node
COMMIT_DATA Committed data on the node in GiB
SWAP_DATA Swapped data on the node in GiB
VOLUME_ID The identifier of the volume.
DELETE_DATA Deleted data on the node in GiB. This includes all data which cannot be deleted immediately, e.g. because of an active backup or shrink operation.
MULTICOPY_DATA Multicopy data on the node in GiB. Multicopy data occurs in case of transactions where one transaction reads old data and the other one writes new data of the same table in parallel.
SNAPSHOT_BACKUP_DATA Snapshot backup data on the node in GiB. This includes all data which is not used by the database any more but cannot be deleted because it is referenced by at least one snapshot backup.