=========空间占用大小============ 查所有的可以改为DBA_segments
0、查看用户表、索引、分区表占用空间
select segment_name, sum(bytes)/1024/1024 Mbytes from user_segments where segment_type in ('TABLE','TABLE PARTITION') group by segment_name order by Mbytes desc ;
1、表占用空间
select segment_name, sum(bytes)/1024/1024 Mbytes from user_segments where segment_type='TABLE' group by segment_name order by Mbytes desc ;
2、索引占用空间
select segment_name ,sum(bytes)/1024/1024 Mbytes from user_segments where segment_type ='INDEX' group by segment_name order by Mbytes desc;
3、分区表TABLE PARTITION占用空间
select segment_name,sum(bytes)/1024/1024 Mbytes from user_segments where segment_type='TABLE PARTITION' group by segment_name order by Mbytes desc;
oracle空间占用大小
最新推荐文章于 2024-08-12 10:29:22 发布