Re: Massive Rollback Segment [message #54527] |
Wed, 20 November 2002 12:33 |
denni50
Messages: 18 Registered: November 2002
|
Junior Member |
|
|
thanks tt for explaining the problem in simplistic
terms.
F.Tollenaar provided an excellent link where the causes
of Rollback Segment errors were clearly explained.
I have since removed all cursor for loops 'commits'
and commit after the entire process is complete.
In fact..last night I re-ran my update scripts,
after having removed the mid-commits, and everything
performed smoothly.
thanks Sanjay, FT and tt..your comments really helped
me better understand how RS work and perform.
denni50
|
|
|