Database Administration (MOSC)

MOSC Banner

segments I_ARGUMENT1,I_ARGUMENT2,I_SOURCE1 grown into huge size

edited Aug 26, 2018 5:04AM in Database Administration (MOSC) 9 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center