11g v$session定位客户端IP

11g v$session 新增PORT 字段 用于描述客户端的端口号

客户机从10.5.129.180 访问10.5.128.28

[oracle@cpool ~]$ netstat -na | grep 10.5.128.28

tcp        0      0 10.5.129.180:34981          10.5.128.28:1521            ESTABLISHED

服务端:

[oracle@perass ~]$ netstat -na | grep 10.5.129.180

tcp        0      0 ::ffff:10.5.128.28:1521     ::ffff:10.5.129.180:34981   ESTABLISHED

SQL> select sid,username,machine,port,program from v$session where sid=196;

       SID USERNAME			  MACHINE	   PORT PROGRAM

---------- ------------------------------ ---------- ---------- ----------------------------------------

       196 CZCB 			  cpool 	  34981 sqlplus@cpool (TNS V1-V3)