oracle通过v$session查找访问客户端的IP地址

1. 找到数据库服务器的process ID

set linesize 200;

col spid for a8

col username for a16

col object_owner for a16

col object_name for a16

col locked_mode for a12

col machine for a12

col os_user_name for a14

SELECT p.spid, s.sid, s.serial#, s.machine,

   to_char(s.logon_time,'yyyy-mm-dd hh24:mi:ss') logon_time, 

       NVL(l.oracle_username, '(oracle)') AS username, 

       d.owner AS object_owner, 

       d.object_name, 

   l.os_user_name,

       Decode(l.locked_mode, 0, 'None', 

                             1, 'Null (NULL)', 

                             2, 'Row-S (SS)', 

                             3, 'Row-X (SX)', 

                             4, 'Share (S)', 

                             5, 'S/Row-X (SSX)', 

                             6, 'Exclusive (X)', 

                             l.locked_mode) locked_mode

FROM v$session s,v$process p, dba_objects d, v$locked_object l

WHERE s.paddr = p.addr 

AND s.machine LIKE '%app-c%'

AND d.object_id = l.object_id

AND s.sid = l.session_id;

2. 查看客户机连接的ip地址与端口和服务器的地址和端口

[root@db01 ~]# netstat -antop | grep 10792

tcp        0      0 ::ffff:172.16.10.37:1521    ::ffff:172.16.10.38:50211   ESTABLISHED 10792/oracleorcl    keepalive (2583.89/0/0)

!!The End!!