9i Parsing Optimization

From: amonte <ax.mount_at_gmail.com>
Date: Wed, 30 Aug 2006 18:20:43 +0200
Message-ID: <85c1fb130608300920oc33c33am566dc08deb489530@mail.gmail.com>

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 Received on Wed Aug 30 2006 - 11:20:43 CDT