Home » RDBMS Server » Performance Tuning » max number of users and sessions (oracle,solaris)
max number of users and sessions [message #329167] Tue, 24 June 2008 07:00 Go to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
Hi Gurus,
How to find out the maximum number of users and sessions conected to the database?
Re: max number of users and sessions [message #329168 is a reply to message #329167] Tue, 24 June 2008 07:04 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Check v$session

RBN
Re: max number of users and sessions [message #329177 is a reply to message #329167] Tue, 24 June 2008 07:46 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
v$session will not give me the number of session that can connect to the database. it will give me number of session that are connected to the database.
Re: max number of users and sessions [message #329182 is a reply to message #329177] Tue, 24 June 2008 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no maximum number of sessions but OS limits on memory and/or process number.

Regards
Michel

[Updated on: Tue, 24 June 2008 07:52]

Report message to a moderator

Re: max number of users and sessions [message #329183 is a reply to message #329167] Tue, 24 June 2008 07:59 Go to previous message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
Thanks.
we can find the max number of process using
show parameter process.
and for user, i dont know how to find it.
Previous Topic: Tuning for Queuing (merged)
Next Topic: How tuning this query ? (merged)
Goto Forum:
  


Current Time: Mon Dec 05 19:32:27 CST 2016

Total time taken to generate the page: 0.06041 seconds