"Michel Cadot" <micadot_at_netcourrier.com> wrote in message news:<9nnnt7$2b9$1_at_s1.read.news.oleane.net>...
> "Larsern" <lars.mollerup_at_niva.no> a écrit dans le message news: 9nnnaq$b3e$1_at_snipp.uninett.no...
> > Hello folks!
> > Has anyone got an SQL statement for listing users currently online your
> > base.(8.1.7) (Instance manager won't do....)
> >
> >
> >
> > TIA
> >
> >
> > Lars Mollerup
> > NIVA, Norway
> >
> >
>
> You can use Oracle TopSession or the v$session view.
> For instance:
> select sid, serial#, username, osuser from v$session
> where type='USER';
It's a matter of habbit but I use "where audsid<>0" clause for that kind of queries.
Received on Thu Sep 13 2001 - 14:18:44 CDT
