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_at_fed1read03>
Date: Sun, 04 Jan 2004 12:24:36 -0800
Message-ID: <6E_Jb.50538$BQ5.396_at_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 - 21:24:36 CET