V$OB_LOG_STAT

Last Updated:2026-09-03 07:27:32

Note

This view was introduced in OceanBase Database V4.0.0.

Purpose

The V$OB_LOG_STAT view displays the Palf status of log streams. You can use this view to perform the following operations:

Query whether a log stream has a leader.
Query the member list (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 the 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.

Columns

Column	Type	Nullable?	Description
TENANT_ID	bigint(20)	NO	The ID of the tenant.
LS_ID	bigint(20)	NO	The ID of the log stream.
SVR_IP	varchar(46)	NO	The IP address of the OBServer node.
SVR_PORT	bigint(20)	NO	The port number of the OBServer node.
ROLE	varchar(32)	NO	The role of the replica. Valid values: `LEADER`: The replica is a leader. `FOLLOWER`: The replica is a follower.
PROPOSAL_ID	bigint(20)	NO	The proposal ID of Paxos.
CONFIG_VERSION	varchar(128)	NO	The version number corresponding to the configuration change.
ACCESS_MODE	varchar(32)	NO	The access mode. Valid values: `APPEND`: The primary tenant can write data to the log stream replica `RAW_WRITE`: The log stream replica is read-only for the standby tenant.
PAXOS_MEMBER_LIST	varchar(1024)	NO	The list of Paxos members.
PAXOS_REPLICA_NUM	bigint(20)	NO	The number of Paxos replicas.
IN_SYNC	varchar(3)	NO	Indicates whether the replica is completely synchronized with the leader.
BASE_LSN	bigint(20)	NO	The maximum recyclable checkpoint.
BEGIN_LSN	bigint(20)	NO	The LSN of the minimum consumption checkpoint.
BEGIN_SCN	bigint(20)	NO	The SCN of the minimum consumption checkpoint.
END_LSN	bigint(20)	NO	The LSN of the maximum consecutive majority checkpoint, also known as the maximum consumption checkpoint.
END_SCN	bigint(20)	NO	The SCN of the maximum consecutive majority checkpoint, also known as the maximum consumption checkpoint.
MAX_LSN	bigint(20)	NO	The LSN of the maximum write point.
MAX_SCN	bigint(20)	NO	The SCN of the maximum write point.
ARBITRATION_MEMBER	varchar(128)	NO	The server address of the arbitration member. Note This column is introduced since OceanBase Database V4.1.0.
DEGRADED_LIST	varchar(1024)	NO	The list of degraded full-featured replicas with arbitration enabled. Note This column is introduced since OceanBase Database V4.1.0.
LEARNER_LIST	longtext	NO	The list of read-only replicas in the current log stream. Note This column is introduced since OceanBase Database V4.2.0.

Sample query

Query the log stream replicas of all tenants from the sys tenant.

obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_LOG_STAT\G

The query result is as follows:

*************************** 1. row ***************************
         TENANT_ID: 1
             LS_ID: 1
            SVR_IP: 172.xx.xx.xx
          SVR_PORT: 2882
              ROLE: LEADER
       PROPOSAL_ID: 1
    CONFIG_VERSION: {proposal_id:1, config_seq:2}
       ACCESS_MODE: APPEND
 PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
 PAXOS_REPLICA_NUM: 1
           IN_SYNC: YES
          BASE_LSN: 134209536
         BEGIN_LSN: 0
         BEGIN_SCN: 2
           END_LSN: 318605869
           END_SCN: 1722479448194293393
           MAX_LSN: 318605869
           MAX_SCN: 1722479448194293393
ARBITRATION_MEMBER:
     DEGRADED_LIST:
      LEARNER_LIST:
*************************** 2. row ***************************
         TENANT_ID: 1001
             LS_ID: 1
            SVR_IP: 172.xx.xx.xx
          SVR_PORT: 2882
              ROLE: LEADER
       PROPOSAL_ID: 1
    CONFIG_VERSION: {proposal_id:1, config_seq:2}
       ACCESS_MODE: APPEND
 PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
 PAXOS_REPLICA_NUM: 1
           IN_SYNC: YES
          BASE_LSN: 268419072
         BEGIN_LSN: 0
         BEGIN_SCN: 2
           END_LSN: 558509064
           END_SCN: 1722479448310385941
           MAX_LSN: 558509064
           MAX_SCN: 1722479448310385941
ARBITRATION_MEMBER:
     DEGRADED_LIST:
      LEARNER_LIST:
*************************** 3. row ***************************
         TENANT_ID: 1002
             LS_ID: 1
            SVR_IP: 172.xx.xx.xx
          SVR_PORT: 2882
              ROLE: LEADER
       PROPOSAL_ID: 1
    CONFIG_VERSION: {proposal_id:1, config_seq:2}
       ACCESS_MODE: APPEND
 PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
 PAXOS_REPLICA_NUM: 1
           IN_SYNC: YES
          BASE_LSN: 67104768
         BEGIN_LSN: 0
         BEGIN_SCN: 2
           END_LSN: 114293403
           END_SCN: 1722479448003583398
           MAX_LSN: 114293403
           MAX_SCN: 1722479448003583398
ARBITRATION_MEMBER:
     DEGRADED_LIST:
      LEARNER_LIST:
*************************** 4. row ***************************
         TENANT_ID: 1002
             LS_ID: 1001
            SVR_IP: 172.xx.xx.xx
          SVR_PORT: 2882
              ROLE: LEADER
       PROPOSAL_ID: 1
    CONFIG_VERSION: {proposal_id:1, config_seq:2}
       ACCESS_MODE: APPEND
 PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
 PAXOS_REPLICA_NUM: 1
           IN_SYNC: YES
          BASE_LSN: 0
         BEGIN_LSN: 0
         BEGIN_SCN: 1722408567239862706
           END_LSN: 86556431
           END_SCN: 1722479448003583398
           MAX_LSN: 86556431
           MAX_SCN: 1722479448003583398
ARBITRATION_MEMBER:
     DEGRADED_LIST:
      LEARNER_LIST:
*************************** 5. row ***************************
         TENANT_ID: 1003
             LS_ID: 1
            SVR_IP: 172.xx.xx.xx
          SVR_PORT: 2882
              ROLE: LEADER
       PROPOSAL_ID: 1
    CONFIG_VERSION: {proposal_id:1, config_seq:2}
       ACCESS_MODE: APPEND
 PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
 PAXOS_REPLICA_NUM: 1
           IN_SYNC: YES
          BASE_LSN: 268419072
         BEGIN_LSN: 0
         BEGIN_SCN: 2
           END_LSN: 553130127
           END_SCN: 1722479448267304616
           MAX_LSN: 553130127
           MAX_SCN: 1722479448267304616
ARBITRATION_MEMBER:
     DEGRADED_LIST:
      LEARNER_LIST:
*************************** 6. row ***************************
         TENANT_ID: 1004
             LS_ID: 1
            SVR_IP: 172.xx.xx.xx
          SVR_PORT: 2882
              ROLE: LEADER
       PROPOSAL_ID: 1
    CONFIG_VERSION: {proposal_id:1, config_seq:2}
       ACCESS_MODE: APPEND
 PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
 PAXOS_REPLICA_NUM: 1
           IN_SYNC: YES
          BASE_LSN: 67104768
         BEGIN_LSN: 0
         BEGIN_SCN: 2
           END_LSN: 121756568
           END_SCN: 1722479448105138696
           MAX_LSN: 121756568
           MAX_SCN: 1722479448105138696
ARBITRATION_MEMBER:
     DEGRADED_LIST:
      LEARNER_LIST:
*************************** 7. row ***************************
         TENANT_ID: 1004
             LS_ID: 1001
            SVR_IP: 172.xx.xx.xx
          SVR_PORT: 2882
              ROLE: LEADER
       PROPOSAL_ID: 1
    CONFIG_VERSION: {proposal_id:1, config_seq:2}
       ACCESS_MODE: APPEND
 PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
 PAXOS_REPLICA_NUM: 1
           IN_SYNC: YES
          BASE_LSN: 67104768
         BEGIN_LSN: 0
         BEGIN_SCN: 1722408696347874714
           END_LSN: 86341601
           END_SCN: 1722479448105138696
           MAX_LSN: 86341601
           MAX_SCN: 1722479448105138696
ARBITRATION_MEMBER:
     DEGRADED_LIST:
      LEARNER_LIST:
7 rows in set

Previous topic

V$OB_KVCACHE

Last

Next topic

V$OB_LS_LOG_RESTORE_STATUS