探究死锁事件v$session中的p1,p2,p3

--实验背景：
--开启两个session通过update同一个表造成死锁。

SYS@PROD1> select sid,event,p1,p2,p3 from v$session where username='SCOTT';

       SID EVENT					    P1	       P2	  P3
---------- ---------------------------------------- ---------- ---------- ----------
	31 enq: TX - row lock contention	    1415053318	   983060	1434
	45 SQL*Net message from client		    1650815232		1	   0

SYS@PROD1> desc v$event_name;
 Name						       Null?	Type
 ----------------------------------------------------- -------- ------------------------------------
 EVENT# 							NUMBER
 EVENT_ID							NUMBER
 NAME								VARCHAR2(64)
 PARAMETER1							VARCHAR2(64)
 PARAMETER2							VARCHAR2(64)
 PARAMETER3							VARCHAR2(64)
 WAIT_CLASS_ID							NUMBER
 WAIT_CLASS#							NUMBER
 WAIT_CLASS							VARCHAR2(64)

SYS@PROD1> select parameter1,parameter2,parameter3 from v$event_name where name='enq: TX - row lock contention';

PARAMETER1
---------------