select count(*) cnt,

session_id sid,

substr(event,1,30) event,

mod(p1,16) as lm,

sql_id,

CURRENT_OBJ# || ' ' || object_name obj

, o.object_type type

, CURRENT_FILE# file#

, CURRENT_BLOCK# block#

, blocking_session bsid

,SAMPLE_TIME

from v$active_session_history ash,

all_objects o

where

event like 'enq: T%'