Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the I/O access resource information of all OBServer nodes.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port of the OBServer node. |
| ENDPOINT | VARCHAR2(256) | NO | The endpoint of shared storage. This field is empty in shared-nothing (SN) mode. |
| PATH | VARCHAR2(1024) | NO | The path in object storage. In SN mode, this field displays the local path. The path can be of the following types: local://, oss://, file://, and s3://. |
| CLASS_ID | NUMBER(38) | NO | An ID used for labeling. The meaning of this field varies depending on the purpose of the object storage bucket.
|
| TYPE | VARCHAR2(32) | NO | The metric type, which can be one of the following types:
|
| REQUIREMENT | NUMBER(38) | NO | The required resources of the server. |
| ASSIGN | NUMBER(38) | NO | The upper limit of the resources specified by the throttling algorithm for the server. |
Sample query
In a user tenant, query the applied and reserved quotas of the following metrics in object storage on all OBServer nodes for clog storage and data storage scenarios. For backup and restore, data import, and data export scenarios, query the applied and reserved quotas of the following metrics in object storage on all OBServer nodes in the tenant.
obclient> SELECT * FROM SYS.GV$OB_SHARED_STORAGE_QUOTA;