『ORACLE』查询连入会话IP地址触发器（11g）

create or replace trigger on_login_trigger
after logon on database
begin
dbms_application_info.set_client_info(sys_context('USERENV','IP_ADDRESS'));
end;
/

select username,sid,serial#,client_info from v$session;

create or replace trigger on_login_trigger
after logon on database
begin
dbms_session.set_identifier(sys_context('userenv','ip_address'));
end;
/

select username,sid,serial#,client_identifier from v$session;