Database Tuning (MOSC)

MOSC Banner

Application slowness due to row locking-AWR

edited May 12, 2020 9:07AM in Database Tuning (MOSC) 16 commentsAnswered ✓

Hello Gurus,

AWS RDS-12.1.0.2.0

One of our application started complaining about slowness when looked at the AWR report during the problem time i see high "Enq:TX -row lock contention" waits taking chunk of DB Time.

No DB/app code changes or any DB parameter changes whatsoever done.

I compare the AWR with the good time and one thing that stand out was its doing lot of Controlfile reads(~149G) during bad time compare to 4G against good time.

I know that row lock issues are related to application code.What could cause sudden row lock contention now?

Any valuable input on this would be greatly helpful.

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