Re: How can I check the Users who are online ?

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860_at_fed1read03>...
> B.Dimple wrote:
> > Hi Oracle Experts,
> >
> > How can I check the Users who are online ?
> >
> > Is there a table name which contains a list of DB users (e.g in
> > SQLServer the table is sysusers) ?
> >
> > B.Dimple
> > Junior DBA
>
> select username, osuser from v$sessions;

Thanks for the quick response.

Unfortunately, when I try your suggestion, I get this error message :-

   "ORA-00942: table or view does not exist"

B.Dimple Received on Sun Jan 04 2004 - 20:38:50 CET