Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: My database is too fast
Hi Billy,
Attended today an excellent seminar by Jonathan Lewis in (not so) sunny Canberra on the CBO where he demonstrated the new 10i feature of the "TRY_HARDER" hint where Oracle will re-parse a statement if it runs like shit.
Guess you don't need it !!
(BTW, the demonstration was a joke that was made even funnier when some believed it :o)
Cheers
Richard
"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:bdh69c$gr$1_at_ctb-nnrp2.saix.net...
> Norman Dunbar wrote:
>
> > two things to try out :
> >
> > 1. Have another cup of coffee
>
> Roger that. Will do so right now.
>
> > 2. Remove said table from your obviously overlarge KEEP POOL :o)
>
> Dammit. Wish it was that simpply. But the CBO insists on being clever and
> doing the count in parallel, using partition iteration on the local
> partition bitmap index.
>
> I don't understand how the CBO can work as designed and not adhere to the
> low standards and expectations from most users...
>
> <muttering> something must be wrong... working as designed.. what the hell
> next... developers that actually know what they're doing.. newbies
actually
> reading the friggen manuals.. <mutter> <mutter> what is this world coming
> too.. best rap artist is white.. best golfer is black.. england beating
the
> aussies in rugby.. <mutter>
>
> --
> Billy
Received on Fri Jun 27 2003 - 08:33:06 CDT