Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which RBS is my Update using ?

Re: Which RBS is my Update using ?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 26 Sep 2002 21:14:05 +0100
Message-ID: <3d937a3b_1@mk-nntp-1.news.uk.worldonline.com>


"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:Luik9.39747$g9.115098_at_newsfeeds.bigpond.com...
> 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.
> >
> >
> >
>
>

ROFL. Paul Received on Thu Sep 26 2002 - 15:14:05 CDT

Original text of this message

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