SNAP_XCMT$ Table In System Tablespace Is Too Big (Doc ID 2176301.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

1) What object(s) and object type(s) are you having issues with?
SNAP_XCMT$, C_OBJ#, C_COBJ#, HIST_HEAD$, etc

2) Please describe your problem; include when the problem started, its duration and what was being done at the time the error was generated or what has changed since this last worked
Top segments in SYSTEM tablespace doesn't look healthy.

OWNER SEGMENT_NAME SEGMENT_TYPE SIZE_MB
-------------------- ------------------------------ ------------------------- ----------
SYS SNAP_XCMT$ TABLE 5385
SYS C_OBJ# CLUSTER 216
SYS C_COBJ# CLUSTER 128
SYS HIST_HEAD$ TABLE 96
SYS LOGMNRG_COL$ TABLE 80
SYS I_CON_MIG1 INDEX 80
SYS C_OBJ#_INTCOL# CLUSTER 80

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