Execute to parse %

What does Execute to parse % signify in Statspack/AWR report.

If this % is  very less  for e.g 2% then it means so many parsing is going on in database,now you have to check whether soft parsing is going on or Hard parsing is going ,

Check Soft parse ratio,If soft parse ratio is quite good like above 90% then it means ,there is less Hard parsing in database but lot of soft parsing is going on ,As Execute to parse ratio is very less then in database all mostly execution are going for soft parsing.

To avoid Soft parsing need to check application behaviour,In Application, cursor should  not be close so earlier.
The only way to modify the execute-to-parse ratio would be to alter the two variables used in the formula. You can change either (1) the number of times you parse or (2) the number of times you execute.

Below is method to calculate Execute to Parse %.

100-( parse/total execution)*100

Hope this helps

Tarun C.