Note
This view is available starting with V4.3.4.
Purpose
This view displays the IO access resource information on 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 number of the OBServer node. |
| ENDPOINT | VARCHAR2(256) | NO | The endpoint of the shared storage. In Shared-Nothing (SN) mode, this field is empty. |
| PATH | VARCHAR2(1024) | NO | The path of the object storage. In Shared-Nothing (SN) mode, it displays the local path. Common path types include: 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 type of the metric. Valid values:
|
| REQUIREMENT | NUMBER(38) | NO | The resource requirements of the server. |
| ASSIGN | NUMBER(38) | NO | The upper limits of the resources specified by the throttling algorithm. |
Sample query
In a user tenant, query the requested and limited quotas for object storage metrics on all OBServer nodes for scenarios such as clog storage and data storage. In scenarios such as backup and restore, data import, and export, query the requested and limited quotas for object storage metrics on all OBServer nodes for the tenant.
obclient> SELECT * FROM SYS.GV$OB_SHARED_STORAGE_QUOTA;