Re: Rollback Segments?

From: PerlMongerWannaBe <davehaas_at_hotmail.com>
Date: Wed, 27 Oct 1999 04:11:24 GMT
Message-ID: <7v5u19$6jj$1@nnrp1.deja.com>

Hi Nick.

If the rollback segments are filling up that means your users are not commiting their transactions in a timely manner. To manually shrink a rollback segment back down to it's optimal size enter the command:

alter system shrink rollback segment x;

Hope that helps :)

Dave

> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 23:11:24 CDT