Re: Rollback segment

[Dave Weber]

It depends if the are public access or private.  Bottom line if you were using them actively, you will slow down since it is likely the remaining segment will have to issue quite a few more extents to keep up with activity.

Tim Sawmiller wrote:

Then everybody will use the one that's left.

[EMAIL PROTECTED] 03/02/01 11:45PM >>>

Hi,

Anyone have idea, how Oracle8i make used of multiple rollback segments to
reduce system contention?
I am currently using 4 rollback segments what will happen if 3 of them are
offline?
 :<(

Thanxs,....