--SYSDBA为模式名,SLI_TEST为表名,查出来的单位为k
SELECT TABLE_USED_SPACE('SYSDBA', 'SLI_TEST')*(PAGE/1024) FROM DUAL
--下面这个语句也可以,和oracle用法类似
select segment_name,sum(bytes/1024) from user_segments where segment_name='SLI_TEST'
原创 | 2022-10-13 13:43:46 |浏览:1.6万
--SYSDBA为模式名,SLI_TEST为表名,查出来的单位为k
SELECT TABLE_USED_SPACE('SYSDBA', 'SLI_TEST')*(PAGE/1024) FROM DUAL
--下面这个语句也可以,和oracle用法类似
select segment_name,sum(bytes/1024) from user_segments where segment_name='SLI_TEST'