Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the I/O access resource information on the current OBServer node.
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 following types are commonly used for this path: local://, oss://, file://, and s3://. |
| CLASS_ID | NUMBER(38) | NO | The ID for labeling. The meaning of this field varies based 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 for 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 application and maximum quotas of the object storage metrics for clog storage and data storage on the current OBServer node. Query the application and maximum quotas of the object storage metrics for backup and restore, data import, and data export on the current OBServer node.
obclient> SELECT * FROM SYS.V$OB_SHARED_STORAGE_QUOTA;