updating the table causes lmode to 3
Hello,
When I update few rows using where clause then lmode shows as 3 in v$lock.
When I execute below statement then I think lock escalation should happen and lmode should be 6 since we are updating whole table and this should be table lock in exclusive instead maintaining so many locks for rows isn't it however this still shows as 3?
SQL> update t1 set t1=2,t2=10;
Best regards,
Vishal