RE: Set transaction use rollback??

Hi Vishak

I think you should use this statement when you want to assign a transaction to a specific Rollback Segment
(generally a BIG Rollback), because the transaction is HUGE (as you said in you mail).

Remember that when you issue a commit or rollback you close the current transaction and you should
issue "SET TRANSACTON USE ROLLBACK.." again in order to assign the following transaction to the previous RS.

This is a possible approach, the other one is to use OPTIMAL setting in your rollbacks and let the BIG transaction be assigned by Oracle to any of them. When the TX has finished (not exactly when you issued the commit, but some time after that) Oracle will SHRINK the rollback segment according to your optimal setting.

hope it helps
DC

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 22, 2001 1:20 AM

> Hello Gurus
>
> I just would like to know when this statement SET TRANSACTON USE ROLLBACK
> SEGMENT 'XXX' should be used exactly.
>
> In the sense should I always write it after a BEGIN(for all my programs)
or
> should I write it in processes which involves HUGE volume of records.
>
> Please clarify
>
> Regards
> Vishak
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Vishak
> INET: vishak.holla_at_wipro.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Diego Cutrone
  INET: dcutrone_at_afip.gov.ar

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).