查询表与索引的物理大小

select segment_name, segment_type, bytes
from dba_segments
where owner = 'SYS'4 and segment_name in (select index_name
from dba_indexes
where table_owner = 'SYS'7 and table_name = 'T'8 union
select 'T' from dual);

[@more@]代码:

---



SYS@HUIYI>create table t

2 (3 col01 date

4 )5 /表已创建。



SYS@HUIYI>insert into t values(sysdate);已创建 1 行。



SYS@HUIYI>commit;提交完成。



SYS@HUIYI>create index t_idx on t(col01);索引已创建。



SYS@HUIYI>select segment_name, segment_type, bytes

2 from dba_segments

3 where owner = 'SYS'4 and segment_name in (select index_name

5 from dba_indexes

6 where table_owner = 'SYS'7 and table_name = 'T'8 union

9 select 'T' from dual);SEGMENT_NAME SEGMENT_TYPE BYTES--------------------------------------------------------------------------------- ------------------ ----------T TABLE 65536

T_IDX INDEX 65536------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/594892/viewspace-924212/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/594892/viewspace-924212/