With Oracle 9204 cursor_sharing = force and stored outlines dont work
together. We are moving from RBO to CBO and we want to preserve the
execution plans for some views. Some of the queries using this view is not
using bind variables.
How do i store outlines for SQLs executed from Oracle Forms , Java Code and
in PL/SQL Packages.Can i just turn on alter session for the sessions running
these SQLs and gather outlines? Is that the correct way to do ?
"Oradba Linux" <techiey2k3_at_comcast.net> wrote in message
news:__ednU9kG_-UHkPcRVn-2w_at_comcast.com...
> 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:53:33 CST
