OceanBase 租户总数量查询
如题
查询sql
收藏
复制链接
微信扫码分享
在小程序上查看
分享
2条回答
默认
最新
查看OB集群所有租户信息: __all_tenant 或 gv$tenant
租户类别compatibility_mode: 0-mysql, 1-oracle
比如:
obclient> select tenant_id, tenant_name, compatibility_mode,zone_list, locality ,primary_zone ,gmt_modified from __all_tenant;
+-----------+----------------------+--------------------+-------------------+---------------------------------------------+-------------------+----------------------------+
| tenant_id | tenant_name | compatibility_mode | zone_list | locality | primary_zone | gmt_modified |
+-----------+----------------------+--------------------+-------------------+---------------------------------------------+-------------------+----------------------------+
| 1 | sys | 0 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | zone1;zone2,zone3 | 2020-12-21 15:57:13.995853 |
| 1001 | gjj_mysql_tent | 0 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | zone1,zone2,zone3 | 2020-12-23 10:39:29.044498 |
| 1002 | gjj_ora_tent | 1 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | zone1,zone2,zone3 | 2020-12-23 14:52:09.341057 |
| 1004 | gjj_ora_tent_restore | 1 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | zone1,zone2,zone3 | 2021-01-26 18:47:23.217573 |
| 1005 | ora_test_tent | 1 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | zone1;zone2;zone3 | 2021-02-01 11:16:11.895747 |
+-----------+----------------------+--------------------+-------------------+---------------------------------------------+-------------------+----------------------------+
5 rows in set (0.01 sec)
obclient>
评论
有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

