Re: 9i Parsing Optimization

Without seeing the statement, I would say max_permutations. Your parse
elapse time consists of mostly cpu time, so that could be it. However it may
not be the (only) one.

Anjo.


On 8/30/06, amonte <ax.mount@xxxxxxxxx> wrote:

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





-- Anjo Kolk Owner and Founder OraPerf Projects tel: +31-577-712000 mob: +31-6-55340888

Other related posts: