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 188.8.131.52 to 184.108.40.206 [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 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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms