| vraahul |
Posted: Dec 26, 2002 04:50:00 PM |
Total Post: 2
Joined: Jan, 2003
|
Hi Guys,
How do I find the number of concurrent users on the system? Is there any $ view that can help me.
Thanks,
David
|
|
|
 taerry |
| Posted: Dec 26, 2002 04:55:00 PM |  |
|
Total Post: 3
Joined: Jan, 2003
|
Hi David,
You can query v$session view to find the no of concurrent users.
e.g
select username from v$session;
Thanks,
Larry
|
|
|
|
|
| parthokonar |
| Posted: Sep 26, 2007 11:34:04 AM | |
|
Total Post: 27
Joined: Sep, 2007
|
dba_users will show all the users on the database
v$session will show all the users who has connected to the server
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:34:47 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
select distinct(username) will give you users connected to database.
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
