| no of users logged on [message #592785] |
Mon, 12 August 2013 06:22  |
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  |
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 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
