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