Database Tuning (MOSC)

MOSC Banner

updating the table causes lmode to 3

edited Feb 5, 2016 1:53PM in Database Tuning (MOSC) 9 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center