Have a session that is doing many, many, samll DML, then commit...No problem. Session is grabbing diff undo segment every time...No problem. UNDO_RETENTION is 5 hours....No problem. At some point today the UNDO tablespace became 100% full and now is 99% full ( I think because of this session). No sessions are waiting or hung because if this...No problem. Will my UNDO tablespace remain 99% full...forever?...for the next 5 hours?...until next shutdown? Thanks, Chris Marquez Oracle DBA Rollback Rbks Init Next Min Max Rbks Rbks OPTIMAL CURRENT Segment Tablespace Ext Ext Ext Ext Status Type SIZE EXTENTS EXTENDS SIZE ---------- ------------ ------------ ------------ ---- ------- -------- --------------------- -------------- ------- ------- -------------- SYSTEM SYSTEM 114,688 1 32,765 ONLINE PRIVATE 6 0 385,024 _SYSSMU1$ UNDOTBS 131,072 2 32,765 ONLINE 37 193 210,493,440 _SYSSMU2$ UNDOTBS 131,072 2 32,765 ONLINE 55 207 253,288,448 _SYSSMU3$ UNDOTBS 131,072 2 32,765 ONLINE 32 200 251,781,120 _SYSSMU4$ UNDOTBS 131,072 2 32,765 ONLINE 26 177 192,077,824 _SYSSMU5$ UNDOTBS 131,072 2 32,765 ONLINE 30 222 235,003,904 _SYSSMU6$ UNDOTBS 131,072 2 32,765 ONLINE 29 165 217,243,648 _SYSSMU7$ UNDOTBS 131,072 2 32,765 ONLINE 168 336 3,858,882,560 _SYSSMU8$ UNDOTBS 131,072 2 32,765 ONLINE 85 243 421,715,968 _SYSSMU9$ UNDOTBS 131,072 2 32,765 ONLINE 53 266 385,998,848 _SYSSMU10$ UNDOTBS 131,072 2 32,765 ONLINE 104 367 264,822,784 11 rows selected. SQL> Chris Marquez Oracle DBA