Tag: process ID

How to find the PID of the process using a specific port?

# lsof -i :9933
COMMAND     PID   USER   FD   TYPE     DEVICE SIZE/OFF NODE NAME
oracle_51 51639 oracle    6u  IPv4 3233899771      0t0  UDP localhost.localdomain:9933
# netstat -nlp|grep 9933
udp   1053952      0 127.0.0.1:9933          0.0.0.0:*                           51639/oracleTESTDB
# fuser -v -n udp 9933
                     USER        PID ACCESS COMMAND
9933/udp:            oracle    51639 F.... oracle_51639_TESTDB

Check Session id(SID) and SQL statement from OS process id(PID) in Oracle

SELECT b.spid,
a.sid,
a.serial#,
a.username,
a.osuser
FROM v$session a, v$process b
WHERE a.paddr = b.addr AND b.spid = '&spid'
ORDER BY b.spid

-- Check SQL statement associated with Process id in Oracle

SELECT RPAD('USERNAME : ' || s.username, 80) ||
RPAD('OSUSER : ' || s.osuser, 80) ||
RPAD('PROGRAM : ' || s.program, 80) ||
RPAD('SPID : ' || p.spid, 80) ||
RPAD('SID : ' || s.sid, 80) ||
RPAD('SERIAL# : ' || s.serial#, 80) ||
RPAD('MACHINE : ' || s.machine, 80) ||
RPAD('TERMINAL : ' || s.terminal, 80)
--RPAD('SQL TEXT : ' || q.sql_text, 80)
FROM v$session s ,v$process p ,v$sql q
WHERE s.paddr = p.addr AND s.sql_address = q.address AND s.sql_hash_value = q.hash_value
AND p.spid = '&spid'