By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

How can I check the Users who are online ?

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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;

Jul 19 '05 #2

P: n/a
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@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
Jul 19 '05 #3

P: n/a
B.Dimple wrote:
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@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

Jul 19 '05 #4

P: n/a
You have to be login as DBA (system or sys) to query V$session view.
Faheem
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396@fed1read03>...
B.Dimple wrote:
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@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

Jul 19 '05 #5

P: n/a
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396@fed1read03>...
B.Dimple wrote:
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@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


Hi Ana,

Thanks again.

B.Dimple
Jul 19 '05 #6

P: n/a
The select_catalog_role role might have to be granted.

Ping
Jul 19 '05 #7

P: n/a
bd*****@myway.com (B.Dimple) wrote in message news:<eb*************************@posting.google.c om>...
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396@fed1read03>...
B.Dimple wrote:
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@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


Hi Ana,

Thanks again.

B.Dimple


Dimple,
Looks like you do not have SELECT privileges on the V$session table.
Ask your DBA to give permissions.
Jul 19 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.