Scripts:segment_size.sql

来源:互联网 发布:钢结构棚子算法 编辑:程序博客网 时间:2024/05/16 09:45
col owner for a20
col segment_name for a40
col tablespace_name for 20
select owner,segment_name,tablespace_name,sum(bytes)/1024/1024/1024 GB from dba_segments where segment_name=upper('&1') group by owner,segment_name,tablespace_name order by gb desc;
0 0
原创粉丝点击