Home » RDBMS Server » Server Administration » processes and sessions settings (oracle 10g suse)
processes and sessions settings [message #437647] Tue, 05 January 2010 06:19 Go to next message
Messages: 6
Registered: December 2009
Location: Muscat
Junior Member
hi ,

i need to set the processes and sessions parameters.

can u advice me how many processes and sessions i have to set ?
and based on what parameters i have to set these ?


Re: processes and sessions settings [message #437651 is a reply to message #437647] Tue, 05 January 2010 06:31 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you please read the documentation before posting your question.
From Database Reference
SESSIONS specifies the maximum number of sessions that can be created in the system. Because every login requires a session, this parameter effectively determines the maximum number of concurrent users in the system. You should always set this parameter explicitly to a value equivalent to your estimate of the maximum number of concurrent users, plus the number of background processes, plus approximately 10% for recursive sessions.

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.

Only YOU can know how many sessions and processes you need.

Previous Topic: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2
Next Topic: Oracle 11g event log file is full
Goto Forum:

Current Time: Fri Jul 28 06:37:52 CDT 2017

Total time taken to generate the page: 0.12603 seconds