FreeLists / oracle-l / Re: OT : 9i Parsing Optimization

["Anjo Kolk" <anjo.kolk@xxxxxxxxxxx>]

Well
I find every OCP question a trick question. Some times you have to answer
the question wrong to get it right :-)


On 9/1/06, Polarski, Bernard <Bernard.Polarski@xxxxxxxxxxxxxx> wrote:
>  A bit OT:
>
> That would be a marvelous trap/question in the OCP exams, much clever than
> the grammatical we usually get.
>
> B. Polarski
>
>
>  ------------------------------
> *From:* Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
> *Sent:* Thursday, 31 August, 2006 6:32 PM
> *To:* Brandon.Allen@xxxxxxxxxxx; Polarski, Bernard; anjo.kolk@xxxxxxxxxxx;
> ax.mount@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: 9i Parsing Optimization
>
>
>  Right, session_cached_cursors can have an impact in reducing the amount
> of work a parse does, but, any time a piece of client code makes a parse
> call, Oracle MUST parse.  It may be a hard parse, a soft parse, or a session
> cursor cache hit, but it is a parse, none the less.  The *ONLY* way to
> reduce parsing is to change the program to parse less.
>
> As others speculated previously, perhaps there's an ODBC or JDBC driver,
> or something, that has an optimization that reduces the number of parse
> calls, that was picked up on the upgrade from 8i to 9i.....
>
> -Mark
>
> *--*
> *Mark J. Bobak*
> *Senior Oracle Architect*
> *ProQuest Information & Learning*



--
Anjo Kolk
Owner and Founder OraPerf Projects
tel:    +31-577-712000
mob: +31-6-55340888