Home » RDBMS Server » Server Administration » Re: Massive Rollback Segment
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
Previous Topic: Re: remote connecting oracle and MS Access
Next Topic: Huge datafiles.
Goto Forum:
  


Current Time: Fri Sep 20 02:23:43 CDT 2024