Database Tuning (MOSC)

MOSC Banner

Using host variables to raise Execute to Parse percentage

edited Nov 1, 2013 9:32AM in Database Tuning (MOSC) 4 commentsAnswered ✓
 Hi, I am worry about the instance Efficiency Percentage “Execute to Parse” of my Database

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center