暂无图片
分享
勿忘心安
2021-03-10
OceanBase 租户总数量查询

如题
查询sql

收藏
分享
2条回答
默认
最新
gelyon

查看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
暂无图片
勿忘心安
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏