no of users logged on [message #592785] |
Mon, 12 August 2013 06:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
8939513598$
Messages: 103 Registered: July 2013 Location: chennai
|
Senior Member |
|
|
Hi Michel Sir, How to find the number of users logged, in a database level(Oracle), b'coz generally in OS level (Linux) , the command will be '$ users',
|
|
|
|
|
Re: no of users logged on [message #592901 is a reply to message #592785] |
Tue, 13 August 2013 00:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hkchital
Messages: 128 Registered: September 2008 Location: Singapore
|
Senior Member |
|
|
Note that V$SESSION shows the number of sessions in the database instance.
If you have an application server maintaining it's own connection pooling, there may be more user "sessions" at the application server sharing the database sessions.
Hemant K Chitale
[Updated on: Tue, 13 August 2013 00:48] Report message to a moderator
|
|
|
Re: no of users logged on [message #592909 is a reply to message #592901] |
Tue, 13 August 2013 01:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
And the question is "How to find the number of users logged, in a database level(Oracle)," so your answer is irrelevant.
Regards
Michel
|
|
|