"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3dece80a$0$239$ed9e5944_at_reading.news.pipex.net>...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:fm1H9.89423$g9.251125_at_newsfeeds.bigpond.com...
> > Hi Niall,
> <snip>
> > As suggested by Billy and Rajxesh, I would take a close look at seeing if
> > you can force the second plan to use the hash join (via hint) and at least
> > get identical plans. If problem goes away, you know that was it.
>
> See my reply to Rajxesh. Basically he and Billy were spot on. Now of course
> we have the minor matter of getting hinted SQL into a third party app with
> no direct control of the sql under standard edition. I have a cunning
> plan....
>
There is a (possible) way. If there are not many Oracle sessions
running at the same time, you can play with hash_area_size
parameter in init.ora. When it set to 16M, CBO uses hash joins
more often. If you have many sessions, it's not a good idea
though.
> BTW congrats on the Ashes, hopefully sometime soon the old fogeys at the MCC
> will see sense (or die off) and allow the actual urn down under where it
> rightfully belongs. There was an interesting piece of analysis by ,I think,
> CMJ in the Times where he pointed out that actually Englands performances
> were improving over the last three Ashes series and that we should be in a
> position to win the trophy by the 2078 series :(.
>
> G'Night
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
Received on Wed Dec 04 2002 - 22:54:26 CST
