Re: Peoplesoft: Prolific Use of EXISTS and HASH hints

From: Ethan Post <nospam_at_nowhere.com>
Date: Tue, 13 May 2003 05:18:03 GMT
Message-ID: <fe%va.826605$L1.240927@sccrnsc02>

Thanks. I will check that out. This is a heavily used system so hopefully this is ALTER SYSTEM capable incase I have to back out. That makes me wonder (not that this really matters since PSOFT hard parses 90% of it's SQL), if a plan is in the cache and you change a parameter like always_semi_join or some other parameter that would effect the plan using ALTER SYSTEM, would it reparse and come up with a new plan next time or would it use the existing plan (assuming it only soft parses).

Ethan

"W.Breitling" <member28455_at_dbforums.com> wrote in message news:2867235.1052717235_at_dbforums.com...
>

> > - Ethan Post
> Have you tried setting always_semi_join=hash ? The default is
> nested_loop - at least in Oracle 8 and 8i; in 9i the dafault changes
> to choose.
>
> --
> Posted via http://dbforums.com
Received on Tue May 13 2003 - 00:18:03 CDT