oracle 统计查询来源IP地址

-- 调用DBMS_SESSION包记录地址

BEGIN

DBMS_SESSION.set_identifier(SYS_CONTEXT('USERENV', 'IP_ADDRESS'));

END;

/

 

-- 创建触发器

create or replace trigger on_logon_trigger

after logon on database

begin

   dbms_application_info.set_client_info(sys_context( 'userenv', 'ip_address' ) );

end;

/

 

-- 查询对应的IP navicat 查询

select  username,program,machine,client_info,sys_context('userenv','ip_address') as ipadd from v$session s where username is not null order by username,program,machine;