Database Tuning (MOSC)

MOSC Banner

Confused about "execute to parse %" in AWR reports - related to Soft Parses

edited Jun 26, 2024 4:14AM in Database Tuning (MOSC) 6 commentsAnswered ✓

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.

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