V$OB_LOG_STAT
Purpose
The V$OB_LOG_STAT view displays the Palf status of the log stream. You can use this view to perform the following operations:
- Query whether a log stream has a leader and the replica of the leader.
- Query the member list, that is, the number of Paxos replicas, of a log stream.
- Query the replica synchronization status.
- Query the recyclable checkpoint of the logs of a log stream.
- Query the log consumption service scope of a log stream based on the log sequence number (LSN) or system change number (SCN).
- Query the access mode of Palf.
The query results vary based on the tenant.
- When you query this view from a sys tenant, the Palf status of all tenant log streams is displayed.
- When you query this view from a user tenant, only the Palf status of the log streams of the current tenant is displayed.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| ROLE | VARCHAR2(32) | NO | The role of the replica. Valid values: |
| PROPOSAL_ID | NUMBER(38) | NO | The proposal ID of Paxos. |
| CONFIG_VERSION | VARCHAR2(128) | NO | The version number corresponding to the configuration change, such as change of the member list, number of replicas, and access mode. |
| ACCESS_MODE | VARCHAR2(32) | NO | The access mode. Valid values: |
| PAXOS_MEMBER_LIST | VARCHAR2(1024) | NO | The list of Paxos members. |
| PAXOS_REPLICA_NUM | NUMBER(38) | NO | The number of Paxos replicas. |
| ALLOW_VOTE | VARCHAR2(3) | NO | Indicates whether to allow to vote in log synchronization. Valid values: |
| IN_SYNC | VARCHAR2(3) | NO | Indicates whether the replica is completely synchronized with the leader. |
| REPLICA_TYPE | VARCHAR2(32) | NO | The replica type. Valid values: |
| BASE_LSN | NUMBER(38) | NO | The maximum recyclable checkpoint. |
| BEGIN_LSN | NUMBER(38) | NO | The LSN of the minimum consumption checkpoint. |
| BEGIN_SCN | NUMBER(38) | NO | The SCN of the minimum consumption checkpoint. |
| END_LSN | NUMBER(38) | NO | The LSN of the maximum consecutive majority checkpoint, also known as the maximum consumption checkpoint. |
| END_SCN | NUMBER(38) | NO | The SCN of the maximum consecutive majority checkpoint, also known as the maximum consumption checkpoint. |
| MAX_LSN | NUMBER(38) | NO | The LSN of the maximum write point. |
| MAX_SCN | NUMBER(38) | NO | The SCN of the maximum write point. |
| ARBITRATION_MEMBER | VARCHAR2(128) | NO | The server address of the arbitration member.
NoteThis column is introduced since OceanBase Database V4.1.0. |
| DEGRADED_LIST | VARCHAR2(1024) | NO | The list of degraded full-featured replicas with arbitration enabled.
NoteThis column is introduced since OceanBase Database V4.1.0. |
| LEARNER_LIST | CLOB | NO | The list of read-only replicas in the current log stream.
NoteThis column is introduced since OceanBase Database V4.2.0. |