Note
This view is available starting with V4.4.1.
Purpose
The DBA_OB_SS_SPACE_USAGE view records the storage space usage on the object storage of the current tenant.
Note
This view is only applicable 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 |
|---|---|---|---|
| ENDPOINT | VARCHAR2(128) | NO | The endpoint of the shared storage. |
| PATH | VARCHAR2(128) | NO | The path of the shared storage. |
| STORAGE_TYPE | VARCHAR2(32) | NO | The storage type. Valid values:
|
| VALUE | NUMBER(38) | NO | The size of the storage space occupied by the STORAGE_TYPE value, in bytes. |
Sample query
In the Shared-Storage (SS) mode, query the storage space usage on the object storage of the current tenant.
obclient(SYS@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_SS_SPACE_USAGE;
The query result is as follows:
+----------+-------+-------------------+----------+
| ENDPOINT | PATH | STORAGE_TYPE | VALUE |
+----------+-------+-------------------+----------+
| UNUSE | UNUSE | Local All Bytes | 0 |
| UNUSE | UNUSE | Shared Data Bytes | 14071279 |
| UNUSE | UNUSE | Shared Meta Bytes | 6406144 |
+----------+-------+-------------------+----------+
3 rows in set