Mapping user connection



SELECT sid,
       s.username,
       s.osuser,
       s.terminal,
       s.module,
       spid 
FROM   v$session s,
       v$process p
WHERE  s.paddr = p.addr;

spid - this is process number in operating system. If you want to kill him, please run:

kill -9 spid