| Bishal |
Posted: Apr 22, 2008 03:58:32 AM |
Total Post: 207
Joined: Apr, 2008
|
| how do i know that how many users are currently connected to my database |
|
|
 GOPU |
| Posted: Apr 22, 2008 04:35:01 AM |  |
|
Total Post: 334
Joined: Apr, 2008
|
select username,state from v$session;
|
|
|
|
|
| Gitesh |
| Posted: Apr 22, 2008 11:46:02 PM | |
|
Total Post: 322
Joined: May, 2005
|
Little correction in above commands.
select username,count(status) from v$session
where username is not null
group by username;
You will get status wise list of users in above query. If you want only that how many users are connected and how many sessions are connected then use following query.
select count(*) from v$session
where username is not null;
|
|
|
|
|
| GOPU |
| Posted: Apr 23, 2008 12:20:29 AM | |
|
Total Post: 334
Joined: Apr, 2008
|
hi,
thanks for correcting me... :)
regards
Gopu
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
