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?



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'

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