Re: Change Rollback Segment

No. Unless you use the 'set transaction' command (which has to be the first line of the transaction, so it shouldn't be needed in many places, unless you are dealing with lots of transactions), then Oracle's policy is to assign your transaction to the rollback segment with the fewest number of active transactions.

Other things being equal, such a policy should mean that all rollback segments eventually becoming more or less the same size as each other.

The only other way to influence Oracle's choice of segment is to offline the ones you don't want used, start your transaction, and then immediately online them again (once a transaction has started, it has to finish in the same rollback segment, so the others don't need to be offline for the duration).

Regards
HJR "Erich Scholz" <Erich-Scholz_at_t-online.de> wrote in message news:qb16hu048kahg2c55ifue7s89al0fmq8q6_at_4ax.com...
> I have a sql-script with many statements. It's working with
> autocommit. The Rollback Segment is too small. There are other bigger
> RBS on the DB.
>
> How can I change the RBS on which the script is working? I do not want
> to do this by "set transaction set rollback segment", because I would
> have to name the RBS in too many places in the script.
>
> I'd rather tell the session, with which RBS it should work. Or maybe
> there is a way to define the default RBS of the user?
>
> TIA
> Erich
> --
> Erich-Scholz_at_t-online.de
Received on Fri Jun 21 2002 - 06:33:16 CDT