select sid,event,p1,p1raw,p2,p3 from v$session where event not like '%message%';
p1 p1raw p2 p3
4 1633 latch free 1610651464 0000000060009748 18 0
latch free:
p1 latch 的地址
p2 latch的编号 = v$latchname.latch#
p3 请求次数
SQL> select name from v$latch where latch#=18;
NAME
--------------------------------------------------
enqueues