Yes I am reading the articles now.
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:crlen6$fr5$1_at_titan.btinternet.com...
>
> outlines are created at the optimization stage.
> If the statement had previously been optimized
> and was sharable, your first call would have
> found it in the library cache (viz soft parse if
> you check v$sysstat).
>
> The mechanism for 'create or replace' does
> not attempt to execute the statement, so goes
> straight into optimization, and produced the
> outline (hard parse recorded in v$sysstat).
>
> The difference is why you can have problems
> trying to set up outlines with cursor_sharing=force
> (or similar).
>
>
> There are a couple of articles of mine on
> www.dbazine.com that might help a bit.
>
> --
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/seminar.html
> Public Appearances - schedule updated Dec 23rd 2004
>
>
>
>
>
>
> "Oradba Linux" <techiey2k3_at_comcast.net> wrote in message
> news:yo2dnW6EuP7EckDcRVn-sA_at_comcast.com...
> >I am really confused about what is happening here. Why an outline is not
> > created when i did an alter session. I am REDHAT LINUX ES3.0 and oracle
> > 9204.
> >
> >
>
>
Received on Fri Jan 07 2005 - 06:40:19 CST
