一、查询本用户的表、视图等
select * from user_tab_comments;
select * from user_col_comments;
二、查询所有表空间的大小
select segment_name,sum(bytes)/1024/1024/1024 gb from dba_segments where owner='用户名' group by segment_name order by GB desc
查询结果如下图:
三、查询某个用户表空间大小
select sum(bytes)/1024/1024/1024 gb from dba_segments where owner='用户名' and segment_name='表名'