【 使用环境 】测试环境
【 OB or 其他组件 】OB
【 使用版本 】4.3.4
【问题描述】在oceanbase中如何获得一个数据库的占用空间
select /*+
query_timeout(30000000) */ a.DATABASE_NAME,
sum(
case
when
b.nested_offset = 0 then
IFNULL(b.data_block_count+b.index_block_count+b.linked_block_count, 0) * 2 *
1024 * 1024
else
IFNULL(b.size, 0)
end
)
/1024.0/1024/1024 as data_size_in_GB
from
CDB_OB_TABLE_LOCATIONS a inner join __all_virtual_table_mgr b
on a.svr_ip =
b.svr_ip and a.svr_port=b.svr_port and a.tenant_id = b.tenant_id and a.LS_ID =
b.LS_ID and a.TABLET_ID = b.TABLET_ID
and a.role =
'LEADER' and a.tenant_id = 1014
and
b.table_type >= 10 and b.size > 0 group by a.DATABASE_NAME;
1 个赞
感谢
厉害