Topenq.sql
-- (c) Kyle Hailey 2007
column wait_event format a40 prompt shadow select o.name, current_obj#, count(*) , to_char(ash.p1,'XXXXXXXX') from sash ash, v$event_name n, obj$ o where n.event#=ash.event# and n.name = 'enqueue' and o.obj# = current_obj# group by o.name, current_obj# , ash.p1 order by count(*) /