| maximum number of sessions [message #151077] |
Tue, 13 December 2005 00:46  |
Natraj
Messages: 53
Registered: March 2003
|
Member |
|
|
|
i get the maximum number of sessions reached error. though i know that the sessions parameter can be increased.i want to know what are the other things that need to be considered? I want to allow maximum number of users to connect to the database as there are lots of testing going on.in the number of sessions is 1.1 * processes +5, but how do i know for a particular server for say 4GB RMAN, i have configured the best possible number of sessions?
|
|
|
|
| Re: maximum number of sessions [message #151140 is a reply to message #151077] |
Tue, 13 December 2005 07:27  |
Frank Naude
Messages: 4590
Registered: April 1998
|
Senior Member |
|
|
Don't make it too complicated: if this wasn't a one-off situation, increase the SESSIONS parameter and get it done with.
Before changing parameters like PROCESSES and TRANSACTIONS, check their high water marks in v$resource_limit.
Best regards.
Frank
|
|
|
|
|
|
| Re: maximum number of sessions [message #151181 is a reply to message #151077] |
Tue, 13 December 2005 10:37 |
Natraj
Messages: 53
Registered: March 2003
|
Member |
|
|
|
no, this is not a one off situation we always face this problem, so we need to fix it, or else as vjedigunta said kill the stalled sessions, we use apache, i am not conversant in it. so do you advise me to increase processes paramter or sessions parameter, i feel in our init.ora we have just set processes parameter, sessions is a little more than that(though i did not see it in init.ora, i checked it from database level), since this will be a real time application lot of hits will be there to the database when it goes live, howveer during testing our testers get the ora-18 error after around 200 connections.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
