Re: which way use to assign the rollback segment?

From: grjohnson <Johnsog123_at_hotmail.com>
Date: 15 Oct 2002 23:03:01 -0700
Message-ID: <32b8a689.0210152203.79c2e396@posting.google.com>

> "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!
> > >

And if they all have the same number of active trasactions? I thought it takes the next one in a round robin algorithm in this case. Received on Wed Oct 16 2002 - 01:03:01 CDT