Re: IP
From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Tue, 23 Apr 2002 14:27:36 GMT
Message-ID: <3CC56E81.E66B5BA_at_shaw.ca>
SYS_CONTEXT('USERENV','IP_ADDRESS'),SYS_CONTEXT('USERENV','HOST'),SYS_CONTEXT('USERENV','OS_USER'), SYS_CONTEXT('USERENV','SESSION_USER'), sysdate from dual;
Date: Tue, 23 Apr 2002 14:27:36 GMT
Message-ID: <3CC56E81.E66B5BA_at_shaw.ca>
try the following, it's a bit of a catch-all (or you can edit it for the relevant bits in the beginning):
set serveroutput on
column SYS_CONTEXT('USERENV','IP_ADDRESS') format a20 column SYS_CONTEXT('USERENV','HOST') format a20 column SYS_CONTEXT('USERENV','OS_USER') format a20 column SYS_CONTEXT('USERENV','SESSION_USER') format a20SELECT
SYS_CONTEXT('USERENV','IP_ADDRESS'),SYS_CONTEXT('USERENV','HOST'),SYS_CONTEXT('USERENV','OS_USER'), SYS_CONTEXT('USERENV','SESSION_USER'), sysdate from dual;
El - Fatih wrote:
>
> How can I find IP address for a session. There is machine name in the
> v$session but i need ip address. Is there a way to find out a ip address for
> a session.
>
> Thanx
Received on Tue Apr 23 2002 - 16:27:36 CEST