Re: How to find out online users

"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';

--
Hope this helps
Michel