Re: Computing statistics and query plans

Hehe That's one of my problems with the Oracle manuals too. Thanks

In article <948871297.23469.0.nnrp-06.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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
>
>

--
Tim Green
ADP, Inc

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 17:03:26 CST