Query to get the IP Adress of connected User in Oracle

Query to get the IP Adress of connected User in Oracle

 

       
SELECT username ,
  status ,
  osuser ,
  process ,
  machine ,
  terminal ,
  logon_time ,
  lockwait ,
  blocking_session_status,
  blocking_instance ,
  blocking_session ,
  UTL_INADDR.GET_HOST_ADDRESS(REGEXP_REPLACE(machine, '^.+\\')) AS client_ip
FROM v$session
WHERE sid='3175'
;


--need a sysdba permission to execute