Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9i Parsing Optimization
Hi Alex
I think the improvemente might be cuased by the new OCIStmtPrepare2 call (introduced in 9.2), this uses a client side sql statement cache to avoid a server side parsing.
Regards
-- LSC On 8/31/06, amonte <ax.mount_at_gmail.com> wrote:Received on Thu Aug 31 2006 - 03:42:07 CDT
>
> Hi
>
> I am checking the ODBC version being used.
>
> It is Merant ODBC v4.1 and has not been changed. My doubt is if this ODBC
> driver depends internallly on OCI version. If that is the case then it
> probably was using OCI8 and now using OCI9 and may be we are talking about
> OCI9 optimization.
>
> All I have is a libodbc.sl which is supposed to be the Merant ODBC, how
> can I check if this has dependency on OCI?
>
> Thanks all
>
> Alex
>
>
>
> On 8/31/06, Anjo Kolk <anjo.kolk_at_oraperf.com> wrote:
> >
> > Part of the OCI8 interface is the capability to execute SQL statements
> > without doing defines (for the select list). So you can do an execute and
> > then after that execute you know what the select list looks like (types,
> > sizes), for this an implicit DESCRIBE (which requires a parse) is done,
> > after that a normal regular parse is done. So that could explain the 2
> > parses in 8. May be that was optimized in oracle9. When you did the defines,
> > one can Fetch the data.
> >
> > If I remember correctly (talking to some folks from siebels many years
> > ago), they do use OCI (not sure if it was OCI8, but most likely)
> >
> > Anjo.
> >
> >
> > On 8/30/06, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk > wrote:
> > >
> > >
> > > I don't know what technology Siebel Tools uses,
> > > but your earlier double call may have been a
> > > "feature" of the ODBC or JDBC or whatever
> > > driver was between Siebel and Oracle, rather
> > > than a bit of the application code.
> > >
> > > I believe there used to be a feature in the Perl
> > > driver, for example, that made it do a parse
> > > call without bind values, followed by an execute
> > > call with bind values - but if the bind types weren't
> > > all character, the execute call would require a
> > > second parse call. It's something like that that
> > > may have gone away on the upgrade.
> > >
> > > Don't ask me to quote specifics - it's a long time
> > > ago and in another version.
> > >
> > >
> > > Regards
> > >
> > > Jonathan Lewis
> > > http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
> > >
> > > The Co-operative Oracle Users' FAQ
> > > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> > >
> > > Cost Based Oracle: Fundamentals
> > > http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
> > >
> > >
> > > ----- Original Message -----
> > > From: "amonte" < ax.mount_at_gmail.com>
> > > To: < jonathan_at_jlcomp.demon.co.uk>
> > > Cc: <oracle-l_at_freelists.org>
> > > Sent: Wednesday, August 30, 2006 9:50 PM
> > > Subject: Re: 9i Parsing Optimization
> > >
> > >
> > > > Anjo and Brandon, I forgot to mention we use RULE BASED OPTIMIZER so
> > >
> > > > permutations shouldnt be a problem. This is not PL/SQL so it cant be
> > > some
> > > > pl/sql optimization. This is a Siebel Workflow Manager Process.
> > > >
> > > > Jonathan, it is Siebel Tools, I understand that from application
> > > codes you
> > > > can invoke two parse calls but what I dont understand is why the
> > > second call
> > > > is not "called" in 9i?
> > > >
> > > > TIA
> > > >
> > > > Alex
> > >
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> > --
> > Anjo Kolk
> > Owner and Founder OraPerf Projects
> > tel: +31-577-712000
> > mob: +31-6-55340888
> >
>
>
-- http://www.freelists.org/webpage/oracle-l