Obtener IP de la máquina conectada a la base de datos

SQL> column USER format a12
SQL> column IP_ADDRESS format a15
SQL> column HOST format a20
SQL> SELECT user, sys_context('userenv','ip_address') IP_ADDRESS, sys_context('userenv','host') HOST from dual;