select
prc.spid, -- Use this number for oradebug setospid
prc.pid -- Use this number for oradebug setorapid
from
v$session ses join
v$process prc on ses.paddr = prc.addr
where
ses.sid = sys_context('userenv', 'sid');
SQL> oradebug setorapid 52 Oracle pid: 52, Windows thread id: 15752, image: ORACLE.EXE (SHAD)
prc.spid in the query above.