SYSTEM Tablespace Using MSSM Is Abnormally Growing And The Clusters C_TOID_VERSION# and/ or C_OBJ#_INTCOL# Are Using Most Of The Space. (Doc ID 943094.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.5 to 10.2.0.4 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 08-Jul-2016***

Symptoms

You could notice that the SYSTEM tablespace is abnormally growing, you try to identify which segments are using most of the space, and you find that the cluster(s) C_TOID_VERSION# and/ or C_OBJ#_INTCOL# is/ are using most of the space.

You can use the below SQL statement to find the top 10 sized segments of the SYSTEM Tablespace:

SQL> col segment_name format a20
SQL> col tablespace_name format a20
SQL> select SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, MB from
(select segment_name, segment_type, tablespace_name,bytes/1024/1024 MB, rank() over(order by bytes desc) srank from dba_segments) where srank <=10;

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms