Note
This view is available starting with V4.0.0.
Purpose
This view displays the status and restore progress of log streams in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| LS_ID | NUMBER | NO | The log stream ID. |
| STATUS | VARCHAR2(100) | NO | The status of the log stream. Valid values:
|
| PRIMARY_ZONE | CLOB | YES | The priority of the log stream for leader election. |
| UNIT_GROUP_ID | NUMBER | NO | The ID of the unit group.
Note
|
| LS_GROUP_ID | NUMBER | NO | The ID of the log stream group. For system log streams (log stream 1) and broadcast log streams, this field is 0, indicating that the log stream does not belong to any log stream group. |
| CREATE_SCN | NUMBER | NO | The starting point of the log stream. |
| DROP_SCN | NUMBER | NO | The point at which the log stream is dropped. This is also the end point of all user data. If the log stream is dropped, this field records the SCN when the log stream is dropped. If the log stream is not dropped, this field is empty. |
| SYNC_SCN | NUMBER | NO | The synchronization point of the log stream. This is the SCN of the last transaction that is successfully synchronized. |
| READABLE_SCN | NUMBER | NO | The readable point of the log stream. This is the minimum SCN of the log stream that can be read. |
| FLAG | VARCHAR2(2048) | YES | The flag of the log stream. Valid values:
NoteThis field is available starting with V4.2.0. |
| UNIT_LIST | VARCHAR2(1216) | NO | The list of units on which the user log stream is distributed. For system log streams and broadcast log streams, this field is empty if no specific location is specified.
Note
|
Sample query
Query the status and restore progress of log streams in the current user tenant.
obclient(SYS@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_LS;
The query result is as follows:
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
| LS_ID | STATUS | PRIMARY_ZONE | UNIT_GROUP_ID | LS_GROUP_ID | CREATE_SCN | DROP_SCN | SYNC_SCN | READABLE_SCN | FLAG | UNIT_LIST |
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
| 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | 1768205378118457001 | 1768205378118457001 | NULL | NULL |
| 1001 | NORMAL | zone1 | 0 | 1001 | 1767769662964400002 | NULL | 1768205378119515000 | 1768205378119515000 | NULL | 1002 |
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
2 rows in set
References
Query the status and restore progress of log streams in all tenants: CDB_OB_LS
For more information about log stream replicas, see Replica introduction.