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.