Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    Unanswered: 'enq: TX - row lock contention'

    i am running a multiple thread test and i get 'enq: TX - row lock contention' when we are inserting unique records.

    I understand that rows are locked when edited but seeing as a completely new record is being created surely this should not cause row locks?

    I am running Oracle Database 11g Enterprise Edition Release - 64bit Production

    Thanking you in advance

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1
    Possibly a parent row is being locked due to a foreign key constraint on the table being inserted?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts