latch free

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

原文地址:https://www.cnblogs.com/hzcya1995/p/13352217.html