Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the I/O operations of all tenant objects in object storage and cloud disks.
Columns
| Column |
Type |
Nullable? |
Description |
| TENANT_ID |
bigint(20) |
NO |
Tenant ID |
| PATH |
varchar(1024) |
NO |
The path is in the format of oss://, file://, or s3://. |
| ENDPOINT |
varchar(256) |
NO |
- In shared-nothing (SN) mode, displays the endpoint of object storage used for backup and restore, data import, and data export.
- In shared-storage (SS) mode, displays the endpoint of object storage used for log (clog) or data (Data) storage and backup and restore, data import, and data export.
|
| TYPE |
varchar(128) |
NO |
Operation type:
READ: read operationWRITE: write operationREAD_BYTES: total amount of traffic entering the object storage network, in bytesWRITE_BYTES: total amount of traffic exiting the object storage network, in bytesTAG: tag type in object storage. This type is not displayed for local disks and cloud disks. |
| TOTAL |
bigint(20) |
NO |
The cumulative value of each type (TYPE):
READ: the number of read operation-related operationsWRITE: the number of write operation-related operationsREAD_BYTES: the total amount of traffic entering the object storage network, in bytesWRITE_BYTES: the total amount of traffic exiting the object storage network, in bytesTAG: the cumulative value of tag types in object storage. This statistic is not displayed for local disks and cloud disks. |
References
DBA_OB_STORAGE_IO_USAGE
