Confused about "execute to parse %" in AWR reports - related to Soft Parses
Hi
I assume "execute to parse %" should always get a low percentage, no matter what you do.
Perhaps I don't understand it or missing in my logic.
1)
I assume you will rarely get a situation where you don't need to soft parse or hard parse.
2)
I assume soft parsing will occur even if you instruct the Optimizer to use the same execution plan, for any value assigned to the bind variable.
3)
I assume that soft parsing will occur even if you use the same exact SQL statement without any bind variables. Unless its cursor cache gets closed - you'll get a hard parse next time you run that SQL.