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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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



Other related posts: