Re: Which RBS is my Update using ?

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:QLZj9.39188$g9.113278_at_newsfeeds.bigpond.com...
> Hi Brian,
>
> But the use of OPTIMAL is the issue.
>
> Daniel's methodology is such that he prefers *not* to use the SET
> TRANSACTION USE ROLLBACK SEGMENT large (for the reasons he's stated) and
> *not* to use OPTIMAL (for the potential performance issues of extents
being
> deallocated during a transaction).
>
> Paul's methodology is such that he also does *not* want to use OPTIMAL
> because of the possible performance issues but *does* prefer to use SET
> TRANSACTION USE ROLLBACK SEGMENT large for his few but pricey large
> transactions such that the majority of his ordinary small transactions can
> use smaller, non optimal constrained rollback segments.
>
> Note there's another current thread 'Optimal size for rollback' where the
> pros and cons of optimal are being debated.
>
> My methodology is that it depends so I can just sit back and watch the
> battle unfold ;)
>
> Cheers
>
> Richard

Spoilsport! Come and join in the fun. I don't think it's that big a deal anyway, but I paid for the full half hour.

Paul. Received on Tue Sep 24 2002 - 16:27:03 CDT