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
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