1. 根据event事件获取对应session在v$session中等待的row_wait_object#,row_wait_file#,row_wait_block#,row_wait_row#
SQL> select a.SID,
2 a.USERNAME,
3 a.ROW_WAIT_OBJ#,
4 a.ROW_WAIT_FILE#,
5 a.ROW_WAIT_BLOCK#,
6 a.ROW_WAIT_ROW#
7 from v$session a
8 where a.username is not null
9 and a.EVENT = 'enq: TX - row lock contention';
SID USERNAME ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
---------- ------------------------------ ------------- -------------- --------------- -------------
62 TEST 88076 4 276 14
row_wait_obj# --等待对象的object_id
row_wait_file# --等待对象的文件号
row_wait_block# --等待对象的块号
row_wait_row# --等待对象的行号
参考session信息脚本:
se