Database Administration (MOSC)

MOSC Banner

what is difference between Row Exclusive and Exclusive

edited Sep 23, 2009 5:25AM in Database Administration (MOSC) 3 commentsAnswered
  i meet some lock in our system ,
i check it  lock with script in it.
what i notice is the Row Exclusive and Exclusive?
what is difference between   Row Exclusive  and    Exclusive?

Operation Lock Mode LMODE Lock Description
------------------------- --------- ----- ----------------
Select NULL 1 null
Select for update SS 2 sub share
Insert SX 3 sub exclusive
Update SX 3 sub exclusive
Delete SX 3 sub exclusive
Lock For Update SS 2 sub share
Lock Share S 4 share
Lock Exclusive X 6 exclusive
Lock Row Share SS 2 sub share
Lock Row Exclusive SX 3 sub exclusive
Lock Share Row Exclusive SSX 5 share/sub exclusive
Alter table X 6 exclusive

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