Hi Gurus,
DB Version 12.1.0.1.0
Oracle Linux 6
My sysaux table space is increasing too fast (32G), i got a "ORA-01691: unable to extend lob segment AUDSYS.SYS_LOB0000092119C00014$$ by 128 in tablespace SYSAUX", I had to add a new datafile to the table space, but it's too much 32GB.
Is there any suggestion for solve this issue??
What can I do to reduce the size of the sysaux??
select segment_name, bytes
from dba_segments
where tablespace_name = 'SYSAUX'
and bytes > 1048576000 order by bytes
SEGMENT_NAME BYTES
------------------------- -----------
SYS_LOB0000092119C00014$$ 36440309760
SELECT SUM(BYTES) seg_size, COUNT(EXTENT_ID), SEGMENT_NAME, SEGMENT_TYPE,
OWNER FROM
DBA_EXTENTS
WHERE TABLESPACE_NAME='SYSAUX' GROUP BY OWNER,SEGMENT_NAME , SEGMENT_TYPE
ORDER BY
SEG_SIZE DESC;
SEG_SIZE COUNT(EXTENT_ID) SEGMENT_NAME SEGMENT_TYPE OWNER
----------- ------------------- ------------------------------ --------------- -----------------
36440309760 777 SYS_LOB0000092119C00014$$ LOBSEGMENT AUDSYS
100859904 70 SYS_LOB0000018450C00025$$ LOBSEGMENT XDB
100663296 83 CLI_SWP$6365ce67$2$1 TABLE AUDSYS
37945344 38 SYS_LOB0000005823C00005$$ LOBSEGMENT SYS
36831232 36 SYS_LOB0000083628C00006$$ LOBSEGMENT MDSYS
18022400 19 SYS_LOB0000085388C00004$$ LOBSEGMENT SYS
15728640 30 I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX SYS
13631488 28 WWV_FLOW_PAGE_PLUGS TABLE APEX_040200
12582912 27 XDB$RESOURCE TABLE XDB
10485760 25 WWV_FLOW_STEP_ITEMS TABLE APEX_040200
10485760 25 CLI_TIME$6365ce67$2$1 INDEX AUDSYS
10485760 25 CLI_SCN$6365ce67$2$1 INDEX AUDSYS
9437184 24 SDO_CS_SRS TABLE MDSYS
9437184 24 CLI_LOB$6365ce67$2$1 INDEX AUDSYS
8585216 10 SYS_LOB0000088075C00007$$ LOBSEGMENT APEX_040200
Thanks in advances.