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: 68625
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: 3174
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: 68625
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: Thu Mar 28 14:16:03 CDT 2024