katjunior

select s.sql_text,s.sql_fulltext from v$sql s 
where sql_id in(SELECT A.SQL_ID FROM V$SESSION A,V$PROCESS B 
WHERE A.PADDR=B.ADDR AND B.SPID='32507')

katjunior

select s.sql_text,s.sql_fulltext from v$sql s 
where sql_id in (SELECT A.SQL_ID FROM V$SESSION A,V$PROCESS B 
WHERE A.PADDR=B.ADDR AND B.SPID='6495')

katjunior

select d.sid,d.serial#,b.spid,d.status,decode(a.block,1,'SIM',0,'não') BLOCK,
c.object_name,d.osuser,d.schemaname,d.program
from v$lock a,dba_objects c, v$session d, v$process b
where a.sid=d.sid and
d.paddr=b.addr
and a.id1=c.object_id(+)
and d.osuser is not null
and d.schemaname <> 'SYS'
order by 1,6 

katjunior

select
   c.owner,
   c.object_name,
   c.object_type,
   b.sid,
   b.serial#,
   d.spid,
   b.status,
   b.osuser,
   b.machine