Re: 9i Parsing Optimization

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