Re: Rollback Segments?

Dave had it right when he said that your people may not be committing in a timely fashion. Another thing that will cause the rollbacks to blow is large data loads. This can be overcome by loading direct. We had that problem and once I had them do their loads direct we didn't have any more problems. Direct loads in some situations are not really an option though so read up on it to make sure that it is a viable option for your situation.

Darren

Nick wrote:
>
> Hi,
>
> We have the standard 4 rollback segments, which are set at roughly 1gig
> each. But with only 4 users, occasionally they get errors stating that
> the rollback segments are full. Is their a way to flush out the rollback
> segments - ? Thanks for any help,
>
> -Nick

Received on Wed Oct 27 1999 - 16:20:00 CDT