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!

concurrency wait on an insert statement

Neo-bFeb 19 2013 — edited Feb 19 2013

Hello All,

I am running Oracle RAC 2 nodes 11g R2 on AIX 7.1

I have a table with unique index, and the application is doing inserts/updates into this table.
Suddenly and for about half a minute I faced a high concurrency waits on all the processes running these inserts for one node. I saw this high concurrency wait in the top activity screen of the OEM only on one of the nodes. knowing that the processes doing these inserts are running on both nodes.
All what I have that in this half minute I see high concurrency wait in OEM top activity screen related to this insert statement and when I clicked on the insert I found high "enq: TX - index contention". Again this was only on one node.

After this half minute everything went back to normal.

What could be the reason and how can I investigate it ?

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2013

Added on Feb 19 2013

#general-database-discussions

3 comments

1,567 views