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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
