Re: How to get the information like IP address,host name etc of connected clients via V$views

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the information like IP address,host name etc of connected clients via V$views

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 20 Feb 2004 18:08:35 +0100
Message-ID: <40363e83$0$28135$636a15ce@news.free.fr>

"David" <dt_146_at_yahoo.co.in> a écrit dans le message de news:d5840ebd.0402200807.27b8589d_at_posting.google.com...
> Hi Every one,
>
> I want to get the information like (IP Address,Hostname,Active
> sessions , Database Server..etc) of the connected clients
> via V$Views (ORACLE).
> And then I like to load these infromation into a table "Client_Table".
> Could some one give me suggestion that which V$ views/method I use in
> order to get the above information and then
> how to load these information into a table "Client_table"?
> Your suggestions will be highly appreciated.
>
> With Regards
>
> David Tan.

Logon trigger and event attribute functions. http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg14evt.htm#1000872

Regards
Michel Cadot Received on Fri Feb 20 2004 - 11:08:35 CST