Note
- For OceanBase Database V4.3.x, this view was introduced in OceanBase Database V4.3.1.
- For OceanBase Database V4.2.x, this view was introduced in OceanBase Database V4.2.4.
Purpose
The GV$OB_TENANT_RESOURCE_LIMIT_DETAIL view displays the limits on the logical resources on all OBServer nodes in the current tenant and the maximum value of each limit.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The remote procedure call (RPC) port number of the OBServer node. |
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| RESOURCE_NAME | VARCHAR2(128) | NO | The name of the resource. |
| LIMIT_TYPE | VARCHAR2(128) | NO | The name of the limit. |
| LIMIT_VALUE | NUMBER(38) | NO | The value of the limit. |
Sample query
Query the limits on the logical resources on all OBServer nodes in the current tenant and the maximum value of each limit.
obclient[SYS]> SELECT * FROM SYS.GV$OB_TENANT_RESOURCE_LIMIT_DETAIL WHERE ROWNUM = 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 (0.015 sec)