Re: Strange problem.

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Wed, 07 Dec 2005 10:23:53 -0500
Message-ID: <dn6uqg$7rg$1@domitilla.aioe.org>

Joel Garry wrote:
>>Have you got an article number or URL?
>
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7931218716504
> and search for the word "rug."
>
> As someone else suggested, you want to store outlines, Plan Stability
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4144341695521
>
>
>>One would think that if the parameter keeps the
>>optimizer from using a hint a run time, it would do the same when you
>>run explain plan.
>
>
> If it starts with an underscore, all bets are off.
>
>

Actually the previous DBA was told by oracle to set this parameter because of bug 3249465 ( http://tinyurl.com/9wm5h ). Received on Wed Dec 07 2005 - 09:23:53 CST