查询oracle用户IP

创建触发器

create trigger on_logon_trigger

after logon on database

begin

      dbms_application_info,set_client_info | sys_contxt | ‘userenv’,'ip_address'));

end;

进行查询

select client_info,machine from v$session;