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
Other related posts:
