请教这个题的答案 -- 以下哪个系统视图能够显示表或分区的Leader副本和Follower副本的准确位置？

培训 & 考证
#1

请教这个题的答案

以下哪个系统视图能够显示表或分区的Leader副本和Follower副本的准确位置？
A. DBA_OB_TABLE_LOCATIONS
B. DBA_OB_TABLET_TO_LS
C. DBA_OB_LS_LOCATIONS
D. DBA_OB_TABLET_REPLICAS

1 个赞
#2

DBA_OB_TABLE_LOCATIONS

1 个赞
#3

也就DBA_OB_TABLE_LOCATIONS视图包含了分区的副本位置信息，其他都不满足

obclient [oceanbase]> select * from DBA_OB_TABLE_LOCATIONS limit 1\G
*************************** 1. row ***************************
    DATABASE_NAME: oceanbase
       TABLE_NAME: __all_core_table
         TABLE_ID: 1
       TABLE_TYPE: SYSTEM TABLE
   PARTITION_NAME: NULL
SUBPARTITION_NAME: NULL
       INDEX_NAME: NULL
    DATA_TABLE_ID: NULL
        TABLET_ID: 1
            LS_ID: 1
             ZONE: zone1
           SVR_IP: 10.186.61.29
         SVR_PORT: 2882
             ROLE: LEADER
     REPLICA_TYPE: FULL
  DUPLICATE_SCOPE: NONE
        OBJECT_ID: 1
  TABLEGROUP_NAME: oceanbase
    TABLEGROUP_ID: 202001
         SHARDING: ADAPTIVE
1 row in set (0.090 sec)
4 个赞
#4

很好

#5

image
image1233×414 55.6 KB

2 个赞
#6

学习到了一个知识

#7

巩固了

1 个赞
#8

成功续费 1%～

#9

选择A