查看Oracle用户占了哪几个表空间及大小

October 14, 2011 | tags Oracle   | views
Comments 1

select *
  from (select owner || '.' || tablespace_name name, sum(b) g
          from (select owner,
                       t.segment_name,
                       t.partition_name,
                       round(bytes / 1024 / 1024 / 1024, 2) b,
                       tablespace_name
                  from dba_segments t)
         where owner not in
               ('SYS', 'OUTLN', 'SYSTEM', 'TSMSYS', 'DBSNMP', 'WMSYS')
         group by owner || '.' || tablespace_name)
 order by name
 




发表评论:

◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。