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?
Thanks, Howard!
"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!
> >
Received on Sat Oct 12 2002 - 22:10:16 CDT