Finding the clients IP address and Hostname

 


SQL>SELECT    SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) Client_APP,
                      SYS_CONTEXT('USERENV', 'HOST', 16) host_name,
                      SYS_CONTEXT('USERENV', 'NETWORK_PROTOCOL', 8) protocol,
                      SYS_CONTEXT('USERENV', 'CURRENT_USER', 8) Username
     FROM DUAL

 

SQL> /

CLIENT_APP
---------------------------------------------------------------
HOST_NAME
---------------------------------------------------------------
PROTOCOL
---------------------------------------------------------------
USERNAME
---------------------------------------------------------------
190.0.0.47
WORKGROUP\AMMAR
tcp
SCOTT