Re: Session: client IP

From: Victor Kolesov <victor_at_prg.akhz.com>
Date: Tue, 5 Dec 2000 13:21:38 +0200
Message-ID: <90iist$nli$1@news.akhz.com>

Hi,

The sesions was opened by Forms 4.5 (Designer or Runtime) have same value in field teminal (v$session) - "Windows PC" . Why? What can I do for determinating host_name (or ip ) the sessions which was opened by Forms 4.5 .

--
Best regards.
Victor Kolesov.
Sybrand Bakker <postbus_at_sybrandb.demon.nl> ÐÉÛÅÔ ×
ÓÏÏÂÝÅÎÉÉ:90h5ad$1778u$6_at_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 Tue Dec 05 2000 - 05:21:38 CST