Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: which way use to assign the rollback segment?
Excuse me, are you sure? I believed that Oracle Engine assigns it to the next available
rollback segment unless you explicitily assign one with "set transaction command". If you
define the rollback_Segments parameter with a list, then they will be assigned in the
order you specify in that list.
"Howard J. Rogers" wrote:
>
> Nope. The rollback segment with the fewest number of active transactions.
>
> Regards
> HJR
>
> "y" <y_at_y.com> wrote in message news:3DA8B10C.B715DE59_at_y.com...
> > Oracle8i EE.
> > Suppose I defined 20 rollback segments. And most of time there are 100
> > active transactions. When a transaction need the rollback segment to
> > save the before-image, In which way Oracle Engine determine to pick up
> > one rollback segment for this transaction? Round Robin?
> > TIA!
> >
-- Julio NegueruelaReceived on Tue Oct 15 2002 - 06:43:15 CDT