Note
This view is introduced in V4.2.0.
Description
This view displays the log streams that existed in the tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| LS_ID | NUMBER | NO | Log stream ID |
| LS_GROUP_ID | NUMBER | NO | Log stream group ID |
| STATUS | VARCHAR2(100) | NO | Current status of the log stream. The possible values are:
|
| FLAG | VARCHAR2(2048) | NO | Log stream flags. The possible values are:
|
| CREATE_SCN | NUMBER | NO | The GTS when the log stream is created. The unit is nanoseconds. |
Examples
Query the log streams that existed in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_LS_HISTORY;
The query result is as follows:
+-------+-------------+--------+------+---------------------+
| LS_ID | LS_GROUP_ID | STATUS | FLAG | CREATE_SCN |
+-------+-------------+--------+------+---------------------+
| 1 | 0 | NORMAL | NULL | 0 |
| 1001 | 1001 | NORMAL | NULL | 1736152507462028000 |
+-------+-------------+--------+------+---------------------+
2 rows in set