Feature
DBA_OB_LS shows the status and restoration progress of log streams.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| LS_ID | NUMBER | NO | The ID of the log stream. |
| STATUS | VARCHAR2(100) | NO | The status of the log stream. Valid values:CREATING: The log stream is being created.CREATED: The log stream has been created.NORMAL: The log stream can provide services.DROPPING: The log stream is to be deleted. You need to migrate the TABLETs from the log stream.TENANT DROPPING: The tenant where the log stream resides is being deleted. You need to delete the log stream.WAIT OFFLINE: The data has been deleted from the log stream. The log stream is waiting for GC.CREATE ABORT: The log stream fails to be created or does not need to be created, and will be deleted soon. |
| CREATE_SCN | NUMBER | NO | The SCN where the log stream started to write logs. |
| DROP_SCN | NUMBER | NO | The SCN where the log stream was deleted and all user data ended. |
| SYNC_SCN | NUMBER | NO | The SCN when the log stream was synchronized. |
| READABLE_SCN | NUMBER | NO | The readable SCNs of the log stream. |
| PRIMARY_ZONE | CLOB | YES | The election priority of the log stream. |
| UNIT_GROUP_ID | NUMBER | NO | The ID of the unit group. |
| LS_GROUP_ID | NUMBER | NO | The ID of the log stream group. |