Oracle: 12.1.0,.2/ 2 node RAC
Below update statement is causing enq: TX - row lock contention wait event. I have access to awr reports only as there are no blocking sessions for me to analyze right now.
Please suggest what can be done to avoid this wait event.
UPDATE user1.TAB1 SET COL_1=COL_1 WHERE (ID = HEXTORAW(:1 ));
the table has just over 9000 rows and elapsed time per execution is ~ 0.12 seconds.
Thanks.