Overview
Displays the log streams that have existed in this tenant's history.
Columns
field |
Type |
Is NULL |
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:
|
| FLAG | varchar(2048) | NO | Log stream tag:
|
| CREATE_SCN | decimal(20,0) | NO | GTS at Log Stream Creation, in Nanoseconds |
Sample query
Query the system tenant for log streams that have existed in this tenant's history.
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