Re: Which RBS is my Update using ?

Tanel Poder wrote:

> Hello,
>
> > What you are missing ... is that rollback segments need to be able to expand to
> > handle the largest transaction on the system. That is not the same as saying they
> > need to permanently be large enough to handle the largest transaction on the
> > system.
>
> I still don't see why rollback segments in my configuration are less
> expandable than "They should all be identical and sized to handle the
> largest transaction on the system" configuration which you posted
> yesterday..
>
> But about the cheap price of disk v.s. administration work cost, I agree
> with you.
>
> Thank you for your time,
> Tanel.

I'm not sure I understand your question. Rollback segments expand. And expand until they either hit the maximum allowed extents parameter or run out of disk space. So as long as any rollback segment can expand enough to hold any transaction which rollback segment becomes irrelevant.

If you try to force a transaction into a specific rollback segment. And for any reason that specific segment is unavailable. The transaction will fail.

Daniel Morgan Received on Wed Sep 18 2002 - 14:39:35 CDT