Remind me...UNDO RETENTION, UNDO ts 100% full.
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Jun 2005 11:51:49 -0400
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
- Follow-Ups:
- Re: Advanced Queue ordering?
- From: Karthik
Other related posts:
- » Remind me...UNDO RETENTION, UNDO ts 100% full.
- » RE: Remind me...UNDO RETENTION, UNDO ts 100% full.
- Re: Advanced Queue ordering?
- From: Karthik