| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: rollback sizing pt 2
That was mentioned as an option too but I am not sure how I can make
an SAP transaction use a specific rollback table. The concept looks
good - just don't know how to implement it.
Thanks for the reply
-vince
On Thu, 14 Aug 2003 10:56:50 -0500, TurkBear <john.greco_at_dot.state.mn.us> wrote:
>Bear in mind that , for any given transaction, the # of rollback segments is not relevant: Only 1 will be used so it needs to
>be big enough to handle the entire transaction - you can commit more often, or create a very large rollback segment and
>specify it with the 'SET TRANSACTION USE ROLLBACK SEGMENT MY_NEW_BIG_RBS' ( your name will vary) as the FIRST statement
>after connecting to run the big batch...( I keep one offline and only bring it online when I want to use it, that way no
>other transaction gets it)
>hth
>
 |
 |