Note
This view is available starting with V4.3.4.
Purpose
This view displays information about the object storage configurations of the shared storage cluster on all OBServer nodes.
Note
This view is applicable only to the Shared-Storage (SS) mode. In the Shared-Nothing (SN) mode, the query result of this view is empty.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| PATH | varchar(1024) | NO | The root path used for object storage. The path usually starts with oss:// or s3://. |
| ENDPOINT | varchar(1024) | NO | The endpoint of the object storage. |
| USED_FOR | varchar(256) | NO | The user of the object storage. Currently, only ALL is supported, indicating that the object storage is used for clog and data. |
| ZONE | varchar(128) | NO | The zone name. |
| STORAGE_ID | bigint(20) | NO | The ID of the object storage path. The same path has the same STORAGE_ID. |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS of the object storage. |
| MAX_BANDWIDTH | bigint(20) | NO | The maximum bandwidth of the object storage, in bytes. |
| CREATE_TIME | timestamp(6) | NO | The creation time of the object storage. |
| AUTHORIZATION | varchar(1024) | NO | The authorization information of the object storage. |
| STATE | varchar(256) | NO | The state of the object storage:
|
| STATE_INFO | varchar(1024) | NO | The state information of the object storage. |
| LAST_CHECK_TIMESTAMP | timestamp(6) | NO | The last check time. |
| EXTENSION | varchar(4096) | NO | Other information about the object storage. |
References
View information about the object storage configurations of the shared storage cluster on the current node: V$OB_SERVER_STORAGE
View information about the object storage configurations of the shared storage cluster on each zone: DBA_OB_ZONE_STORAGE