Note
This view is introduced in V4.2.0.
Purpose
This view displays the log streams that existed in the tenant.
Columns
| Column | Type | Nullable? | Description | |
|---|---|---|---|---|
| LS_ID | bigint(20) | NO | Log stream ID | |
| LS_GROUP_ID | bigint(20) | NO | Log stream group ID | |
| STATUS | varchar(100) | NO | Current status of the log stream. Valid values:
|
|
| FLAG | varchar(2048) | NO | Log stream flag. Valid values:
|
BLOCK_TABLET_IN: the broadcast log stream does not allow Tablets to be created. |
| CREATE_SCN | decimal(20,0) | NO | GTS at which the log stream was created, in nanoseconds. |
Sample query
The following example shows how to query the log streams that existed in the user 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 |
| 1001 | 1001 | NORMAL | | 1736152507462028000 |
+-------+-------------+--------+------+---------------------+
2 rows in set