Re: OT : 9i Parsing Optimization

  • From: "Anjo Kolk" <anjo.kolk@xxxxxxxxxxx>
  • To: Bernard.Polarski@xxxxxxxxxxxxxx
  • Date: Fri, 1 Sep 2006 08:53:55 +0200

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 J. Bobak*
*Senior Oracle Architect*
*ProQuest Information & Learning*

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

Other related posts: