| Bishal |
Posted: May 08, 2008 07:24:55 AM |
Total Post: 98
Joined: Apr, 2008
|
What is an sql query to find out the users currently connected to given database.... Users currently connected not all the users.
Thanx in advance |
|
|
 Mohammed Taj |
| Posted: May 08, 2008 09:17:25 AM |  |
|
Total Post: 634
Joined: Jul, 2007
|
SELECT COUNT(*) FROM V$SESSION;
|
|
|
|
|
| Prakash |
| Posted: May 09, 2008 01:23:39 AM | |
|
Total Post: 112
Joined: Aug, 2006
|
Select username,sid,serial#,program from v$session where username is not null;
|
|
|
|
|
| GOPU |
| Posted: May 12, 2008 02:14:08 AM | |
|
Total Post: 149
Joined: Apr, 2008
|
select username,count(status) from v$session where username is NOT NULL group by username;
select count(*) from v$session where username is not null;
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
