Remind me...UNDO RETENTION, UNDO ts 100% full.

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

--
http://www.freelists.org/webpage/oracle-l