select segment_name,segment_type,bytes/1024/1024 from dba_segments where owner='SYSTEM' order by bytes desc
select segment_type, sum(bytes)/1024/1024 from dba_segments where tablespace_name='AA' group by segment_type;
select bytes/1024/1024 sizeM, owner, segment_name
from dba_segments
where tablespace_name = 'DD'
and segment_type = 'TABLE' order by sizeM desc;
2009年7月9日星期四
订阅:
博文评论 (Atom)
没有评论:
发表评论