# 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'
Make DBA Life Easy 