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

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 04 Jan 2004 12:24:36 -0800
Message-ID: <6E_Jb.50538$BQ5.396@fed1read03>

B.Dimple wrote:

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

select username, osuser from sys.v$session Received on Sun Jan 04 2004 - 14:24:36 CST