Skip to Main Content

Oracle Database Discussions

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!

enq TX - row lock contention

613179Feb 16 2009 — edited Feb 18 2009
Hi,

I have a table:

MyTable (
f1 varchar2(4),
f2 varchar2(2),
f3 varchar2(10),
f4 varchar2(4),
f5 number(2),
f6 date,
f7 varchar(2)
PrimaryKey (f1,f2))

the table has 1 b-tree and 2 bitmap inserts.
I receive enq TX - row lock contention during insert

insert into MyTable (f1,f2,f6) values (:a,:b,sysdate);

and the insertion is too slow. The only wait observed on the database is row lock contention which has a huge occurrence (more than 512msec waits). Can you help me with this problem. How does the inserts affect row locks and what is the reason for waits?
regards
This post has been answered by Charles Hooper on Feb 17 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2009
Added on Feb 16 2009
15 comments
20,514 views