Re: Session: client IP

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 4 Dec 2000 22:52:00 +0100
Message-ID: <90h5ad$1778u$6@ID-62141.news.dfncis.de>

"Antonio Sant" <asant_at_iol.it> wrote in message news:idTW5.31825$hk4.1203687_at_news.infostrada.it...
> Is possible to get the ip of a client connected to Oracle?
>
> I'm thincking of a user with SQL-Navigator or SQL-Plus that login into a
DB.
>
> Please help.
>
>

Could you *please* refrain from crossposting? It doesn't necessarily enlarge your audience and I may now answer a question which already has been answered in a different group.
You can get the terminal name, which usually equates to the client pc name from v$session. Obviously you would need an external function to translate the dns name back to IP.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Dec 04 2000 - 15:52:00 CST