Oracle后台获取客户端的IP地址

v$session中不能直接获得客户端IP地址，在数据库中创建一个追踪客户端IP地址的触发器：

 

create or replace trigger on_logon_trigger after logon on database
begin
    dbms_application_info.set_client_info(sys_context('userenv', 'ip_address'));
end;
/

查询:

select sid,serial#,username,program,machine,client_info
from v$session
where username is not null
order by username,program,machine;