Note
- This view is available starting with V4.3.1 in V4.3.x.
- This view is available starting with V4.2.4 in V4.2.x.
Purpose
The V$OB_TENANT_RESOURCE_LIMIT_DETAIL view displays the resource limits and their upper limits for all tenants on the current OBServer.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer. |
| SVR_PORT | bigint(20) | NO | The RPC port of the OBServer. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| RESOURCE_NAME | varchar(128) | NO | The name of the resource. |
| LIMIT_TYPE | varchar(128) | NO | The name of the limit. |
| LIMIT_VALUE | bigint(20) | NO | The value of the limit. |
Sample query
Query the resource limits and their upper limits for all tenants on the current OBServer.
obclient[oceanbase]> SELECT * FROM oceanbase.V$OB_TENANT_RESOURCE_LIMIT_DETAIL LIMIT 5;
The query result is as follows:
+----------------+----------+-----------+---------------+---------------+---------------------+
| SVR_IP | SVR_PORT | TENANT_ID | RESOURCE_NAME | LIMIT_TYPE | LIMIT_VALUE |
+----------------+----------+-----------+---------------+---------------+---------------------+
| xx.xx.xx.xx | 2882 | 1 | ls | configuration | 90 |
| xx.xx.xx.xx | 2882 | 1 | ls | memstore | 9223372036854775807 |
| xx.xx.xx.xx | 2882 | 1 | ls | memory | 70 |
| xx.xx.xx.xx | 2882 | 1 | ls | data_disk | 9223372036854775807 |
| xx.xx.xx.xx | 2882 | 1 | ls | clog_disk | 32 |
+----------------+----------+-----------+---------------+---------------+---------------------+
5 rows in set