The following question came up on the comp.databases.oracle.server newsgroup a little while ago:
What is the interpretation of the following:
- Misses in library cache during parse
- (Misses while looking for plan in library cache–Hard parse)
- Misses in library cache during execute
- (Misses while about to execute the plan and found it missing/invalid in library cache)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.02 0.02 0 0 0 0
Execute 7 0.09 0.08 0 5 0 0
Fetch 2017 0.63 0.75 203 47302 0 15000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2026 0.75 0.86 203 47307 0 15000
Misses in library cache during parse: 1
Misses in library cache during execute: 5
