Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Which RBS is my Update using ?
In the Red corner, we have Paul weighing in at 85kgs. He looks strong
tonight, with his little RBS jabs working effectively most of the time and
when required the large RBS uppercut available to be called upon. His
weakness, what if the large RBS uppercut is not there when he needs it, he
could be in real trouble then.
In the Blue corner, we have Daniel weighing in at 85 kgs also. A veteran this guy, fully armed with large RBS punches when required. They may not always be big punches at the start, but he can usually build them up as the bout goes on. His weakness, he may not have the resources if he needs to throw a big punch combination at the end.
Ding ding, there goes the bell ...
Richard ;)
"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
news:3d90dc3c$2_2_at_mk-nntp-1.news.uk.worldonline.com...
> "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 Wed Sep 25 2002 - 08:15:04 CDT