Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: which way use to assign the rollback segment?

Re: which way use to assign the rollback segment?

From: y <y_at_y.com>
Date: Sun, 13 Oct 2002 03:10:16 GMT
Message-ID: <3DA8E3D1.6CEAE76C@y.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US