SYSTEM tablespace is growing up fast on oracle 11g version databases
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
0