Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UNDO segments in 9.2
Gene,
Are you using Automatic (System Managed) UNDO? or the traditional Rollback segment method?
If you are using Automatic UNDO, you should have more than 2 segments in the UNDO tablespace. The number of segments initially created is the function of processes and the minimum I have been able to create is 4 undo segments.
The problem you describe sounds more like a Rollback Segment problem. Unless there is a transaction in the 'other' rollback segment, it will not be shrunk. Check out www.optimaldba.com/library.html and www.evdbt.com/papers.htm for papers on Undo Internals and ORA-01555. They should explain your situation.
Dan Fink
-----Original Message-----
Sent: Tuesday, January 07, 2003 4:49 PM
To: Multiple recipients of list ORACLE-L
Hi all:
I'm seeing something odd with the undo segments in Oracle 9.2. I have a 1G undo tablespace and am trying to import a 200M table. This is the only transaction going on at the time and it is failing because it is running out of space. When I check the undo segments I see TWO undo segments of a significant size. One that is used by my import and one more, which eats up about a half of the tablespace. I thought that Oracle would use up the space taken by this "other" segment, but it doesn't and my import fails. What am I not knowing about the undo segments and oracle9.2?
thanks for any help
Gene
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 08 2003 - 11:14:44 CST
![]() |
![]() |