select b.sid,b.username,b.status,c.type,c.lmode,c.request,d.name,sql_fulltext from v$sql a, v$session b,v$lock c, sys.obj$ d 
where b.sid=c.sid 
and a.sql_id=b.sql_id 
and d.obj# = c.id1;