Purpose
The oceanbase.DBA_OB_LS_HISTORY view displays the historical log streams of the current tenant.
Note
This view is introduced since OceanBase Database V4.2.0 and is not supported in the current OceanBase Database version.
Columns
| Column |
Type |
Nullable? |
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. Valid values:
CREATING: The log stream is being created.NORMAL: The log stream is normal.DROPPING: The log stream is being dropped.PRE_TENANT_DROPPING: This is a special state of system log streams, which indicates that all log streams in the tenant are being dropped.- TENANT_DROPPING: The log stream is being dropped because the tenant has been dropped.
DROPPED: The log stream has been recycled or is being recycled.WAIT_OFFLINE: The log stream is waiting to be recycled.CREATE_ABORT: The creation of the log stream is aborted. |
| FLAG |
varchar(2048) |
NO |
The flag of the log stream. Valid values:
Empty: indicates a normal log stream.DUPLICATE: indicates the broadcast log stream of a user tenant. Replication tables are created on the broadcast log stream.BLOCK_TABLET_IN: indicates that tablets cannot be created on this log stream. |
| CREATE_SCN |
decimal(20,0) |
NO |
The SCN when the log stream was created, in nanoseconds. |
