EXA_VOLUME_USAGE

The system table shows details of the database usage of the 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
VOLUME_ID The identifier of the volume
IPROC Number of the node
LOCALITY Describes the locality of the master segment. If the value is FALSE, then a performance degradation of I/O operations is probable.
REDUNDANCY Redundancy level of the volume
HDD_TYPE Type of HDDs of the volume
HDD_COUNT Number of HDDs of the volume
HDD_FREE Physical free space on the node in GiB of all disks of the volume
VOLUME_SIZE Size of the volume on the node in GiB
USE Usage of the volume on the node in percent, i.e. 100% - (UNUSED_ DATA/VOLUME_SIZE)
COMMIT_DATA Committed data on the node in GiB
SWAP_DATA Swapped data on the node in GiB
UNUSED_DATA Unused data on the node in GiB. Be aware that volume fragmentation might prevent complete use of all unused data.
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 is data which exists in multiple versions; it is generated when parallel transactions operate on the same data, for instance when one transaction reads some rows from a table and another transaction writes the very same rows in the same table.
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.