SQL & PL/SQL

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!

row lock waits

baskar.lAug 9 2010 — edited Aug 9 2010

Hi all,

How to avoid row lock waits ...

SQL statements were found waiting for row lock waits.

   RECOMMENDATION 1: Application Analysis, 2.2% benefit (1147 seconds)
      ACTION: Significant row contention was detected in the TABLE
         "APPS.JSW_LOT_PACKSLIP" with object id 438239. Trace the cause of row
         contention in the application logic using the given blocked SQL.
         RELEVANT OBJECT: database object with id 438239
      RATIONALE: The SQL statement with SQL_ID "aghksygukwpg4" was blocked on
         row locks.
         RELEVANT OBJECT: SQL statement with SQL_ID aghksygukwpg4
         UPDATE JSW_LOT_PACKSLIP PACK SET PACK.DELIVERY_ID = :B3 WHERE
         PACK.LOT_ID = :B2 AND PACK.PACKSLIP_NO = :B1

thanks,
baskar.l

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2010

Added on Aug 9 2010

6 comments

2,665 views