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 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. |
