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