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!

Can log file sync event cause enq: TX row lock contention?

ronald_2017Nov 10 2021

Hi All,

I came across that there are many enq: TX row lock contention happen during a particular period of time. When I check the blocking_session, it is written log file sync event. I am just wondering does this kind of locking happen? What do you recommend?

Thanks

Comments
Post Details
Added on Nov 10 2021
1 comment
303 views