Overview
The GV$OB_TENANT_RESOURCE_LIMIT.Detail view displays the logical resource limits imposed on the current tenant across all OBServer nodes, along with the upper limits for each constraint.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | IP Address of OBServer |
| SVR_PORT | bigint(20) | NO | RPC Port of OBServer |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| RESOURCE_NAME | varchar(128) | NO | Resource Name |
| LIMIT_TYPE | varchar(128) | NO | Limit Name |
| LIMIT_VALUE | bigint(20) | NO | Limit value |
Sample query
Query the logical resource limits of the current tenant across all OBServer nodes, including the upper limits for each limit.
obclient[oceanbase]> SELECT * FROM oceanbase.GV$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 | 1002 | ls | configuration | 90 |
| xx.xx.xx.xx | 2882 | 1002 | ls | memstore | 9223372036854775807 |
| xx.xx.xx.xx | 2882 | 1002 | ls | memory | 8 |
| xx.xx.xx.xx | 2882 | 1002 | ls | data_disk | 9223372036854775807 |
| xx.xx.xx.xx | 2882 | 1002 | ls | clog_disk | 27 |
+----------------+----------+-----------+---------------+---------------+---------------------+
5 rows in set