tkprof and parse count?

From: <ryan.gaffuri_at_cox.net>
Date: Mon, 8 Mar 2004 14:50:02 -0500
Message-Id: <20040308195001.RHGQ11398.lakemtao02.cox.net@smtp.east.cox.net>

Below is a simple tkprof output. Why is my parse count = 4? if there is no CPU time used? I take this to mean, I did not incur a hard parse? How come the 'count' goes up? I can't find this in the docs on metalink.

select 2
from
 dual

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        4      0.00       0.00          0          0          0           0
Execute      4      0.00       0.00          0          0          0           0
Fetch        8      0.00       0.00          0         12          0           4


------- ------  -------- ---------- ---------- ---------- ----------  ----------

total       16      0.00       0.00          0         12          0           4



----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Mar 08 2004 - 13:46:33 CST