Database Administration (MOSC)

MOSC Banner

SYSTEM tablespace is growing up fast on oracle 11g version databases

edited May 17, 2012 2:48PM in Database Administration (MOSC) 5 comments
 Hi,
System tablespace is growing up very fast on Oracle 11g version of database. We are facing this issue on 11.2.0.1, 11.2.0.2 and 11.2.0.3. Auditing is not enabled for any version of database. It is evident that ARGUMENT$, SOURCE$ segment and its indexes are consuming more space.  Please find list of segment which are consume space in the SYSTEM tablespace.

BANNER
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

*********************************************************************************************

OWNER  SIZE_GB SEG_TYPE      SEG_NAME TABLESPACE_NAME
SYS  35.3925781 TABLE ARGUMENT$ SYSTEM
SYS  28.7792969 INDEX I_ARGUMENT1

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