SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select for update performance

1006937Apr 27 2014 — edited Apr 28 2014

Hi,

Oracle 11.2.0.2

In my application, I have performance issue with some "select ... for update" queries

when I execute them they are instantaneous but in AWR they are slow

what is the difference with the same query without for update ?

what I can do to speed it up ?

Thanks for you help

Locked Post

New comments cannot be posted to this locked post.

Locked on May 26 2014

Added on Apr 27 2014

4 comments

3,003 views