Re: CBO & different execution plans

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 8 Apr 2007 15:43:35 +0100
Message-ID: <Q8idnQEz9N2TnYTbnZ2dnUVZ8vydnZ2d@bt.com>

"Matthias Hoys" <anti_at_spam.com> wrote in message news:4617abb4$0$13866$ba620e4c_at_news.skynet.be...
>
>>
>
> By accident, I found the solution for this problem on MetaLink :
>
> Bug 4652274 - Explain Plan Differs With Different Users
>
> It has to do with the init parameter secure_view_merging, which is new
> since 10gR2. Setting it to FALSE in the spfile and boucing the instance
> resolved all my problems ... Now queries on view from another schema have
> the same exection plans when executed by the view owner compared to
> another user.
>
> Matthias
>
>
>

Thanks for the feedback.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Sun Apr 08 2007 - 09:43:35 CDT