select b.SID,b.USERNAME,a.OWNER,a.OBJECT_NAME,c.LOCKED_MODE,d.SQL_ID,d.SQL_FULLTEXT,
d.PARSING_SCHEMA_NAME,b.SQL_ADDRESS
from all_objects a, v$session b, v$locked_object c,v$sql d
where a.OBJECT_ID=c.OBJECT_ID
and b.sid= c.SESSION_ID
and b.SQL_ID=d.SQL_ID;