Re: 9i Parsing Optimization

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 30 Aug 2006 21:33:59 +0100



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


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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006