ORACLE查看表占用空间的大小

查询object的大小，按照降序排序

select *　from user_segments s where s.BYTES is not null order by s.BYTES desc

或

select a.segment_name,

a.segment_type,

a.bytes,

a.bytes / 1024 / 1024 byte_m,

b.created

from dba_segments a

inner join all_objects b

on b.object_type = 'TABLE'

and a.owner = b.owner

and a.segment_name = b.object_name

where a.owner = '用户名'

and a.segment_type = 'TABLE' /* and a.bytes>50000000*/

order by a.bytes desc;

巴特西

ORACLE查看表占用空间的大小

最新文章

热门文章