Explaination of
- 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)
source : https://jonathanlewis.wordpress.com/2007/07/19/library-cache-miss/