查看表所占空间
表空间
查看某张表所占用的空间
select tablespace_name,to_char(sum(bytes)/(1024*1024),'999G999D999') CNT_MB from Dba_Extents
where owner=upper('&OWner') and segment_name = upper('&Table_name') and Segment_type like 'TABLE%'
group by Tablespace_name;
select tablespace_name,segment_name,to_char( bytes/(1024*1024),'999G999D999') CNT_MB from Dba_Extents
where owner=upper('&OWner') and segment_name like upper('&Table_name') and Segment_type like