Re: using a Rollback Segment for all transactions

bertrand Quatromme wrote:

> I work on a datawarehouse.
> I have many transactions which works on multi-threaded sessions.
>
> I try to have all my transaction use a rollback segment which is not
> always the default one.
>
> Actually I have only found the following command :
>
> set transaction use rollback segment RBS_DSS;
>
> But Can I do it at the session level ? or for the particular user which
> runs these transactions (at the time I create this user for example like
> when I choose the default tablespace) ?
>
> Thanks for all help.
>
> --
> bertrand

It would be a good thing if you just forgot about SET TRANSACTION. If your rollback segments are properly sized and present in sufficient number about all you can do with SET TRANSACTION is make a mess of things.

But in answer to your question no you can not assign a user to a rollback segment. SET TRANSACTION must be issued at the beginning of each session and again immediately following every COMMIT and ROLLBACK.

Daniel Morgan Received on Wed Nov 20 2002 - 13:31:16 CST