How to Determine The Lock Type and Mode from an Enqueue Wait

Doc ID: Note:413934.1

WAIT #1: nam='enqueue' ela= 3007866 p1=1414332419 p2=30152 p3=0

The P1 value is 1414332419 which in hex is 544D0003, the first four digits are: 54 and 4D.
54 hex = "T" in ASCII
4D hex = "M" in ASCII
So, this is a "TM" lock type.

The last digit is the lock mode that is being requested. The modes are:

• 0 - none
• 1 - null (NULL)
• 2 - row-S (SS)
• 3 - row-X (SX)
• 4 - share (S)
• 5 - S/Row-X (SSX)
• 6 - exclusive (X)