Re: Ip address

Adi,

Since nobody has responded to your question, I'll provide what I know and it isn't much.
Take a look at the terminal column of v$process and the terminal and machine columns of v$session. I could swear I've seen the ip address pop up for some connections on some servers. It may be related to how the user connects, or to some network configuration. Try that, otherwise your UTL command may be a more consistent way to get this info.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l