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
prabhaher
Messages: 11
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 ?


prabhaher


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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Can you please read the documentation before posting your question.
From Database Reference
Quote:
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.

Quote:
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.

Regards
Michel
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: Sun Dec 01 14:15:02 CST 2024