find_latch_holders.sql
Download Script
select sid||','||serial# from v$session where saddr in (select KGLLKSES from x$kgllk where KGLLKMOD=3) /
Download Script
select sid||','||serial# from v$session where saddr in (select KGLLKSES from x$kgllk where KGLLKMOD=3) /