Re: Computing statistics and query plans

My biggest problem with the manuals is trying to find something that I know exists.

You might look in:

    SQL reference under Anaylze
    Oracle Concepts under Shared Pool
    Oracle Tuning under Tuning Memory and Optimization

but I can't give you an guaranteed location. Sorry

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

wtgreen_at_my-deja.com wrote in message <86l7m6$301$1_at_nnrp1.deja.com>...
>Thanks, this was exactly what I was looking for. Excuse my use of the
>term "query plan" - my Sybase roots are showing. : ) Do you know by
>the way in the documentation where this is stated, however? While I
>have suspected as much, I'd like to know where to point others here
>that question the accuracy of this statement, which up until this
>point, has really just been an assumption of mine.
>
>In article <948827711.25304.0.nnrp-09.9e984b29_at_news.demon.co.uk>,
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>>
>> I think you have a terminology mix-up there.
>>
>> A 'pre-parsed' SQL statement in the shared_pool
>> is loosely speaking an in-memory stored execution
>> plan. With this interpretation the answer to the
>> original question is that such statements are
>> invalidated and a new path evaluated automatically.
>>
>> --
>>
>> Jonathan Lewis
>> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Received on Wed Jan 26 2000 - 01:13:29 CST