Skip to Main Content

Oracle Database Discussions

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: TM - contention

User_3YG3JJun 30 2015 — edited Jun 30 2015

Hello Everyone,

Just One day before one Developer told me that my application hangs too much. So when it hangs next time I queried v$session and in the event I found 'enq: TM - contention'. So I google this event and I found that there is a locking issue of table. So making an index in the foreign key column will solve your problem and problem is solved.

But I want to know How index comes into the picture ? What index actually doing that cause my issue to be resolved.

Please help me out to understand this.

Comments

BluShadow
Maybe a quick search on the internet has the answer...

http://dba.ipbhost.com/index.php?showtopic=8736
21205
Answer
It's probably a problem with your tool. Assuming you're on Oracle 11gR1, run the script in SQL*Plus and it will work.
Marked as Answer by 663394 · Sep 27 2020
SomeoneElse
The CONTINUE statement is a new feature of 11g.

You didn't tell us what version you are using.
663394
Thanks I actaully stumbled on that site after posting the question.Any way as 'someone else' pointed continue is not supported in my version (10 g). Thanks a lot everyone for your time.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 28 2015
Added on Jun 30 2015
5 comments
1,730 views