9i Parsing Optimization

From: amonte <ax.mount@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 30 Aug 2006 18:20:43 +0200

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

Follow-Ups:

Re: 9i Parsing Optimization
From: Anjo Kolk

Re: 9i Parsing Optimization
From: Jonathan Lewis

9i Parsing Optimization

Other related posts: