Using host variables to raise Execute to Parse percentage
Execute to Parse %:75.17
I run a 3rd party AWR advisor and tells me “You have more than 55,756 unique SQL statements entering your shared pool, with the resulting overhead of continuous RAM allocation and freeing within the shared pool…Excessive hard parsing can occur when you have non-reusable SQL statements without host variables……. Set the cursor_sharing parameter for an easy way to make SQL reentrant and remember that you should always use host variables in you SQL so that they can be reentrant…”
parse count (hard) is