Skip to Main Content

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!

enq: US – contention-Possible Causes

Sunil KhaireFeb 11 2015 — edited Feb 12 2015

Hi ,

I am facing one problem , when I am running one procedure standalone it runs very fast but at some time when I run the same procedure via four to five different session its taking time.

Procedure is like copy a single order with all its line details to new one.

What could be possible causes of "enq: US – contention" those I am getting in TKPROF.

This is something can I achieve by tuning the query?

Any suggestion from where should I start?

Thanks in Advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2015
Added on Feb 11 2015
5 comments
1,389 views