Re: Session: client IP
Date: Mon, 4 Dec 2000 22:52:00 +0100
Message-ID: <90h5ad$1778u$6_at_ID-62141.news.dfncis.de>
[Quoted] [Quoted] "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.
>
>
[Quoted] [Quoted] Could you *please* refrain from crossposting? It doesn't necessarily enlarge
[Quoted] your audience and I may now answer a question which already has been
answered in a different group.
[Quoted] 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 - 22:52:00 CET