应该是审计造成的吧?之前我是通过以下命令查看的:
[php]
SELECT SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024,TABLESPACE_NAME FROM DBA_SEGMENTS WHERE BYTES/1024/1024 > 80;
[/php]
昨天发现AUD$和AUD的索引巨大,比别的大几个数量级,于是我就把AUD和AUD的索引移出来了,专门建了自动扩展的AUD空间和AUD索引空间,结果AUD表空间马上扩展到6G多……
今天根据楼上的指示,我查得结果如下:
[php]
set linesize 120
col segment_name for a30
select * from (
select /*+parallel(t,8)*/
segment_name, sum(bytes) / (1024 * 1024 * 1024) segment_bytes, count(*) ext_quan
from dba_extents t
where tablespace_name = 'SYSTEM'
group by tablespace_name, segment_name
) x where x.ext_quan > 1 order by x.segment_bytes desc;
SEGMENT_NAME SEGMENT_BYTES EXT_QUAN
------------------------------ ------------- ----------
IDL_UB1$