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 to [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version to [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 08-Jul-2016***


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
(select segment_name, segment_type, tablespace_name,bytes/1024/1024 MB, rank() over(order by bytes desc) srank from dba_segments) where srank <=10;



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