Hello,
My SYSTEM tablespace keeps increasing but I can't figure out why this is happening. It looks like SYS_LOB0000514333C00041 and SYS_LOB0000514333C00040 are two biggest offenders. My system tablespace just keeps increasing. Can you please eplain to me what is SYS_LOB0000514333C00041 and SYS_LOB0000514333C00040? I have no idea what that is and why it keeps increasing.
OWNER SEGMENT_NAME SEGMENT_TYPE SIZE_IN_MB TABLESPACE_NAME
-------------------- ----------------------------------- ------------------ ---------- ------------------------------
SYSTEM SYS_LOB0000514333C00041$$ LOBSEGMENT 32446 SYSTEM
SYSTEM SYS_LOB0000514333C00040$$ LOBSEGMENT 30104 SYSTEM
SYS IDL_UB1$ TABLE 256 SYSTEM
SYS C_OBJ#_INTCOL# CLUSTER 104 SYSTEM
SYS SYS_LOB0000479031C00045$$ LOBSEGMENT 88 SYSTEM
SYS SOURCE$ TABLE 72 SYSTEM
SYS C_OBJ# CLUSTER 44 SYSTEM
SYS I_H_OBJ#_COL# INDEX 44 SYSTEM
SYS SNAP_XCMT$ TABLE 42 SYSTEM
SYS IDL_UB2$ TABLE 30 SYSTEM
SYS I_COL1 INDEX 27 SYSTEM