Home » RDBMS Server » Server Administration » Database sessions (Oracle 11g, Linux)
Database sessions [message #580646] Tue, 26 March 2013 07:37 Go to next message
tariqmd
Messages: 1
Registered: July 2010
Location: Riyadh
Junior Member


Hello,

I have a simple question about database sessions. The value of parameter "sessions" is set to 500 and the users connect to database through an application server(Jboss). There are more than 500 users connect to the database through application.

My question is, how more than 500 users can connect to the database without any issue, if we set the value of "sessions" parameter to 500?

Regards,
Tariq.
Re: Database sessions [message #580647 is a reply to message #580646] Tue, 26 March 2013 07:56 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
1) Is it a RAC Server or any other Cluster ?
2) What is your connection pooling method?
3) How do you know that more than 500 are connected ?

Sriram Sanka
Re: Database sessions [message #580657 is a reply to message #580647] Tue, 26 March 2013 11:07 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) If it is RAC you can have 500 sessions per instance
2) If your application server use a pool of connections you can have more than 500 sessions on your application server and less than that on your instance
3) Good question

Regards
Michel
Previous Topic: About an error after login
Next Topic: Comparing DB parameters
Goto Forum:
  


Current Time: Thu Mar 28 16:20:25 CDT 2024