find_latch_holders.sql
Download Script
select sid||','||serial# from v$session where saddr in (select KGLLKSES from x$kgllk where KGLLKMOD=3) /
Cheeky Cockatoo
Life Advice and Stories, Travel, Oracle Tech, Good Food and More
Life Advice and Stories, Travel, Oracle Tech, Good Food and More
Download Script
select sid||','||serial# from v$session where saddr in (select KGLLKSES from x$kgllk where KGLLKMOD=3) /