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

Hi Everyone,

I like to inform you that I don't have metalink support. I am still looking for your suggestion about my query.

Thanks

David

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0402201526.1913e2a6_at_posting.google.com>...
> dt_146_at_yahoo.co.in (David) wrote in message 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.
>
> If you have support, get on metalink and look at their PDA tool. Very
> intersting, especially the unix version which is all shell scripts
> that make pretty html output.
>
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=139597.1
>
> Also check out the top tech docs link, which can be drilled down to
> some very informative scripts.
>
> jg
Received on Fri Feb 20 2004 - 23:37:58 CST