doc

    Name:   latchhld.sql

    Author: Mark Gurry

    This script lists who is holding which latches.

#

ttitle 'Latch Holders'

SELECT l.name "Latch Held", p.username "User Holding Latch"
  FROM v$process p,v$latchholder l
 WHERE l.pid  = p.pid;