Unix Top.PID and V$session.Process

[Sharma]

Try this one.

select P.spid "OS Thread", S.username "Name-User", S.osuser, S.program
from V$PROCESS P, V$SESSION S
where P.addr = S.paddr
and S.username is not null;