TYPE2 Objects Filling up UNDO
Hello all!
One of my three Production UNDO tablespaces is filling up much faster than the other two - here is a snapshot of free space:
TABLESPACE_NAME SUM(BYTES)/1024/1024/1024
------------------------------ -------------------------
UNDOTBS1 53.6245117
UNDOTBS2 4.15234375
UNDOTBS3 50.522644
If I pull the segments from each UNDO tablespace they are all SYS-owned TYPE2 segment-types. But the ones in UNDO2 tablespace are significantly larger than those that are in UNDO1 and UNDO3. I don't want to just add more tablespace - trying to figure out if this is some sort of bug.
OWNER SEGMENT_NAME SEGMENT_TYPE SUM(BYTES)/1024/1024
--------------- ---------------------------------------- ------------------ --------------------
SYS _SYSSMU767_3284342863$ TYPE2 UNDO 407.125