Database Tuning (MOSC)

MOSC Banner

Same plan hash value?

edited May 18, 2009 3:32AM in Database Tuning (MOSC) 6 commentsAnswered
Hi all,

Need some advices from the experts.

What happens when 2 sql execution has the same plan hash value? One of my application appears slow and when i check the top sql activity, i found that 2 sql statements issued by 2 users have the same plan hash value. The event for this user also shows that there is tx row lock contention.

Now, my question is will having the same hash value cause any row lock contention?

Thanks!

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