Re: IP-Adress of SQL-Connect

Klaus Schmenger <Klaus.Schmenger_at_InfraServ.hoechst.com> writes:

> is it possible to find out the IP-Address from which a connect to an
> Oracle-Database is made. I can only find the server process but I think
> there must be a way to find out to which client this server process
> sends and receives data.
>
> Greetings
>
> Klaus Schmenger
>
> --

Do a select from v$session_connect_info. It will show you the addresses from which clients are connected.

--

                                        Rick
                                        Rick Wessman
                                        Distributed Data Security
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com