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;
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;