OraFAQ Forum: Performance Tuning » max number of users and sessions

Home » RDBMS Server » Performance Tuning » max number of users and sessions (oracle,solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

max number of users and sessions [message #329167]

Tue, 24 June 2008 07:00

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?

Report message to a moderator

Re: max number of users and sessions [message #329168 is a reply to message #329167]

Tue, 24 June 2008 07:04

Brayan
Messages: 315
Registered: June 2002

Senior Member

Check v$session

RBN

Report message to a moderator

Re: max number of users and sessions [message #329177 is a reply to message #329167]

Tue, 24 June 2008 07:46

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.

Report message to a moderator

Re: max number of users and sessions [message #329182 is a reply to message #329177]

Tue, 24 June 2008 07:52

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Previous Topic:	Tuning for Queuing (merged)
Next Topic:	How tuning this query ? (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Oct 04 04:46:00 CDT 2025