Overview
Displays the size of all user tables under all tenants (based on the leader replica in a multi-replica environment).
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | varchar(128) | NO | Tenant ID |
| TABLE_ID | bigint(20) | NO | Table ID |
| TENANT_NAME | varchar(128) | NO | Tenant name |
| DATABASE_NAME | varchar(128) | NO | Database Name |
| TABLE_NAME | varchar(256) | NO | Table name |
| OCCUPY_SIZE | decimal(42,0) | NO | Data volume stored on disk after table compression, in bytes |
| REQUIRED_SIZE | decimal(42,0) | NO | The actual disk space occupied by the data compacted and stored on disks after table compression, in bytes |
References
- View the detailed storage usage of each tenant across all nodes: oceanbase.CDB_OB_SPACE_USAGE
- View detailed information about storage space usage of each tenant on each node: oceanbase.CDB_OB_SERVER_SPACE_USAGE