Note
This view was introduced in version V4.2.0.
Description
This view displays the log streams that existed in the tenant.
Fields
| Field | Type | Not null | Description |
|---|---|---|---|
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| LS_GROUP_ID | bigint(20) | NO | The ID of the log stream group. |
| STATUS | varchar(100) | NO | The status of the log stream. The possible values are as follows:
|
| FLAG | varchar(2048) | NO | The flags of the log stream. The possible values are as follows:
|
| CREATE_SCN | decimal(20,0) | NO | The GTS when the log stream is created. The unit is nanoseconds. |
Examples
Query the log streams that existed in the current tenant from the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_LS_HISTORY;
The query result is as follows:
+-------+-------------+--------+------+------------+
| LS_ID | LS_GROUP_ID | STATUS | FLAG | CREATE_SCN |
+-------+-------------+--------+------+------------+
| 1 | 0 | NORMAL | | 0 |
+-------+-------------+--------+------+------------+
1 row in set