Database Tuning (MOSC)

MOSC Banner

The causes of row contentions

edited Apr 27, 2009 3:59AM in Database Tuning (MOSC) 5 commentsAnswered
Hi all,

for security reason I have removed the SQL on which referring tables name.

it is the part of addm report

my concern what is the reason behind row contentions.

       RECOMMENDATION 1: Application Analysis, 2% benefit (7608 seconds)
      ACTION: Significant row contention was detected in the INDEX
         "xxxx.xxxxxx" with object id 566394. Trace
         the cause of row contention in the application logic using the given
         blocked SQL.
         RELEVANT OBJECT: database object with id 566394
      RATIONALE: The SQL statement with SQL_ID "4drqk5m36ffn2" was blocked on
         row locks.
         RELEVANT OBJECT: SQL statement with SQL_ID 4drqk5m36ffn2
         UPDATE "xxxxxxxxx" "A1" SET "STATUS_V" =

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center