Re: which way use to assign the rollback segment?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 13 Oct 2002 10:07:45 +1000
Message-ID: <sH2q9.51534$g9.149850@newsfeeds.bigpond.com>

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 - 19:07:45 CDT

This message: [ Message body ]
Next message: Howard J. Rogers: "Re: #pages read per I/O?"
Previous message: John Sinclair: "Oracle 8.x on Redhat 8.0?"
In reply to: y: "which way use to assign the rollback segment?"
Next in thread: y: "Re: which way use to assign the rollback segment?"
Reply: y: "Re: which way use to assign the rollback segment?"
Reply: Julio: "Re: which way use to assign the rollback segment?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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