Re: stored outlines ...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 7 Jan 2005 07:45:43 +0000 (UTC)
Message-ID: <crlen6$fr5$1@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 - 01:45:43 CST