Same plan hash value?
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!