Oracle - Select Process ID

oracle_process_id.sql

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