达梦数据库查看表的大小、字符集、页大小等

--1、创建收集表
create
        table table_count
        (
                owner         varchar(100),
                table_name    varchar(100),
                used_space_mb varchar(100)
        );

--2、循环插入所有表的信息
declare
begin
        for rec in
        (
                select owner, table_name from all_tables order by 1, 2
        )
        loop
                insert into table_count
                select
                        rec.owner     ,
                        rec.table_name,
                        table_used_pages(rec.owner, rec.table_name)*(page()/1024)/1024
                from
                        dual;
        end loop;
end;

--3、查询
select
        t.owner              ,
        t.table_name         ,
        t.used_space_mb                      as MB,
        CAST(t.used_space_mb as number)/1024 as GB
from
        table_count t
where
        table_name like 'GSI_PRO%'
order by
        GB desc





--查看字符集，0[GB18030]，1[UTF-8]，2[EUC-KR]
select sf_get_unicode_flag();
--查看页大小，执行下面任一语句，执行结果单位为字节，例如8192，表示8K
select page();
SELECT SF_GET_PAGE_SIZE();
select para_name,para_value from v$dm_ini where para_name ='GLOBAL_PAGE_SIZE';