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

On 8/30/06, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>
>
> You don't say what the front-end code is, but there
> are environments where the client libraries do a parse
> call followed by a parse and execute call - which
> gives you the two parses per execute that your
> 8i tkprof file is showing.
>
>
> 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: <oracle-l_at_freelists.org>
> Sent: Wednesday, August 30, 2006 5:20 PM
> Subject: 9i Parsing Optimization
>
>
> > Hi
> >
> > I have TKPROFed some batch processes running in Oracle 8i. After
> upgraded to
> > 9i I monitored the same batch processes and I notice Parsing has been
> > reduced by 50% without changing any code.
> >
> > Does anyone know what Optimization is this? I have not changed any
> > parameters. Only added automatic pga.
> >
> >
> > TIA
> >
> > Alex
> >
> >
> > 8i:
> >
> > call count cpu elapsed disk query current
> > rows
> > ------- ------ -------- ---------- ---------- ---------- ----------
> > ----------
> > Parse 120 0.43 0.44 0 0
> > 0 0
> > Execute 60 0.01 0.03 0 0
> > 0 0
> > Fetch 60 0.05 1.51 157 829
> > 0 0
> > ------- ------ -------- ---------- ---------- ---------- ----------
> > ----------
> > total 240 0.49 1.98 157 829
> > 0 0
> >
> > 9i
> >
> > call count cpu elapsed disk query current
> > rows
> > ------- ------ -------- ---------- ---------- ---------- ----------
> > ----------
> > Parse 60 0.01 0.01 0 0
> > 0 0
> > Execute 60 0.01 0.03 0 0
> > 0 0
> > Fetch 60 0.05 1.33 165 828
> > 0 0
> > ------- ------ -------- ---------- ---------- ---------- ----------
> > ----------
> > total 180 0.07 1.37 165 828
> > 0 0
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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