Database Tuning (MOSC)

MOSC Banner

Wait Event: enq: TX - row lock contention

edited Mar 17, 2015 11:19AM in Database Tuning (MOSC) 6 commentsAnswered

I have a 3rd party application but I am trying to figure out the problem to help them.

There is one table when ever it gets update query with different where clauses , it shows wait event "Wait Event: enq: TX - row lock contention".

If we have 10 update query on this table, all will go to show wait event and get into  "Row-X (SX) " mode.

There are many forum are saying increase inittrans - not sure about this or check unique indexes any duplicate records which I don't find the case.

If any of you have faced similar situation and fix the problem then pls share.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center