Find IP address of machine to audit in Oracle

-- Find IP address of machine to audit in Oracle
-- i.e., who is executing queries manually ( except web / app session)
-- Applicable to Oracle 11.1.x.x.x in any OS platform

Step:1: Collect port number from gv$session for the particular session
--------------------------------------------------------------------------------------------
sql> SELECT username, seconds_in_wait, machine, port, terminal,
program, module, service_name
FROM gv$session WHERE type = 'USER'
and lower(program) in ('plsqldev.exe','sqlservr.exe','toad.exe');

Note: You can use other .exe programs if any other tool / program to trace.

Step:2 : Use port number in below query in ssh / telnet session

$ netstat -an | grep 1524

output:

tcp        0      0 ::ffff:10.80.8.8:1521       ::ffff:10.40.33.183:1524    ESTABLISHED

Thanks
Do not forget to write comments...