Re: 9i Parsing Optimization

Hmm

I need to have a look at that, the Merant ODBC Driver being used can be used for both Oracle 8i and 9i. I am not sure if it would be clever enough to detect oci version and run OCIStmtPrepare for 8i and OCIStmtPrepare2 for 9i?

Thanks all

On 8/31/06, Anjo Kolk <anjo.kolk_at_oraperf.com> wrote:
>
> Only when the code has been written to use that call.
>
> Anjo.
>
>
> On 8/31/06, LS Cheng <exriscer_at_gmail.com> wrote:
> >
> > 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:
> > >
> > > 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
> > > >
> > >
> > >
> >
>
>
> --
> Anjo Kolk
> Owner and Founder OraPerf Projects
> tel: +31-577-712000
> mob: +31-6-55340888
>

--
http://www.freelists.org/webpage/oracle-l