Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: OT : 9i Parsing Optimization
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_at_atosorigin.com> 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_at_il.proquest.com]
> *Sent:* Thursday, 31 August, 2006 6:32 PM
> *To:* Brandon.Allen_at_OneNeck.com; Polarski, Bernard; anjo.kolk_at_oraperf.com;
> ax.mount_at_gmail.com; oracle-l_at_freelists.org
> *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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 01 2006 - 01:53:55 CDT
![]() |
![]() |