Home » RDBMS Server » Server Administration » no of users logged on (Oracle 10.2.0.4.0, RedHatLinux-5)
no of users logged on [message #592785] Mon, 12 August 2013 06:22 Go to next message
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 #592790 is a reply to message #592785] Mon, 12 August 2013 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59083
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query v$session.

Regards
Michel
Re: no of users logged on [message #592792 is a reply to message #592790] Mon, 12 August 2013 06:56 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2306
Registered: May 2013
Location: World Wide on the Web
Senior Member
Or gv$session, if it is RAC.

Dynamic Performance Views
Re: no of users logged on [message #592901 is a reply to message #592785] Tue, 13 August 2013 00:47 Go to previous messageGo to next message
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
Michel Cadot
Messages: 59083
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
Previous Topic: ORA-01157: cannot identify/lock data file 201
Next Topic: ORA-01654: unable to extend index
Goto Forum:
  


Current Time: Tue Sep 16 09:13:13 CDT 2014

Total time taken to generate the page: 0.20008 seconds