TKPROF of trace file - Parsing ??

The following is a tkprof of an trace file. I see a lot of parse counts (1394) and misses in library cache is 0. Does this mean that all the parses are soft parses?

Quote:

---

SELECT ACTIVITY_NAME
FROM
D_ACTIVITIES WHERE LOWER(ACTIVITY_CODE) = :1


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1394 0.00 0.00 0 0 0 0
Execute 1394 0.00 0.00 0 0 0 0
Fetch 1394 0.00 0.00 0 1394 5576 1394
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4182 0.00 0.00 0 1394 5576 1394

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 38 (U_TS)

Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL D_ACTIVITIES


Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
1 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'D_ACTIVITIES'

********************************************************************************

---

What is soft parses? do you think it was not even touching the Dictionary cache?


VAST

Quote:

---

Originally posted by ggnanaraj
The following is a tkprof of an trace file. I see a lot of parse counts (1394) and misses in library cache is 0. Does this mean that all the parses are soft parses?

---

Yes, all those are soft parses. For more info refer to http://asktom.oracle.com/pls/ask/f?p...D:920429344869