输入如下语句即可
SELECT segment_name AS TABLENAME,SUM(BYTES)/1024/1024 FROM user_segments WHERE segment_name IN
(select table_name from user_tables WHERE USER = ‘DSG’)
GROUP BY segment_name
ORDER BY 2 DESC
如果查询单张表,可以把
SELECT segment_name AS TABLENAME,SUM(BYTES)/1024/1024 FROM user_segments WHERE segment_name IN
(‘TES_TB’)
GROUP BY segment_name
ORDER BY 2 DESC