segments I_ARGUMENT1,I_ARGUMENT2,I_SOURCE1 grown into huge size
Dear DBA folks,
Good Day!!!
I have found System tablespace growing into huge size. below is the list of largest objects in the system tablespace.
now i have two concerns.
1. what is the reason of the objects grown into huge size.
2. how to reclaim storage from those objects.
SQL> select owner, segment_name, segment_type, bytes/1024/1024 "MB" from dba_segments
where tablespace_name = 'SYSTEM' AND rownum <=100
AND bytes/1024/1024 > 1 order by bytes desc; 2 3
OWNER SEGMENT_NAME SEGMENT_TYPE MB
-------------------- ------------------------- ------------------------- ----------
SYS I_ARGUMENT1 INDEX 50419
SYS I_ARGUMENT2 INDEX 41178
SYS I_SOURCE1 INDEX 482
SYS SYS_LOB0000980495C00100$$ LOBSEGMENT 290
SYS SYS_LOB0000975305C00100$$ LOBSEGMENT 288