Note
This view is available starting with V4.0.0.
Purpose
This view displays the status and recovery progress of log streams in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| LS_ID | NUMBER | NO | The ID of the log stream. |
| 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 column displays 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 point marks the end of all user data. If the log stream is dropped, this column records the SCN at which the log stream is dropped. If the log stream is not dropped, this column is empty. |
| SYNC_SCN | NUMBER | NO | The synchronization point of the log stream. This point marks the SCN of the last transaction that is successfully synchronized. |
| READABLE_SCN | NUMBER | NO | The readable point of the log stream. This point marks the minimum SCN at which the log stream can be read. |
| FLAG | VARCHAR2(2048) | YES | The flag of the log stream:
NoteThis column is available starting with V4.2.0. |
| UNIT_LIST | VARCHAR2(1216) | NO | The list of units on which the user log stream is distributed. The value of this column is empty for system log streams and broadcast log streams if no specific location is specified.
Note
|
Sample query
Query the status and recovery progress of log streams in the current 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 recovery progress of log streams in all tenants: CDB_OB_LS
For more information about log stream replicas, see Replica introduction.