Topobj.sql
-- (c) Kyle Hailey 2007
column wait_name format a30 column object_name format a25 prompt shadow select * from ( select o.object_name object_name, current_obj#, count(*) , n.name wait_name from sash ash, v$event_name n, sash_objs o where n.event#=ash.event# and o.object_id = ash.current_obj# group by o.object_name, ash.current_obj# , n.name order by count(*) desc ) where rownum < 21 / ~