Home » RDBMS Server » Server Administration » MAXIMUM sessions and processes
MAXIMUM sessions and processes [message #353998] Thu, 16 October 2008 00:56 Go to next message
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
Member
Hi

I want to know what is the Maximum limit for processes and sessions in oracle 10g enterprise edition?

i want to make 5000 concurrent connection on one user?
WHAT ARE THE PARAMETERS TO SET?


so can any one give me the steps for this?


please help me.........

thanks

[Updated on: Thu, 16 October 2008 00:57]

Report message to a moderator

Re: MAXIMUM sessions and processes [message #354001 is a reply to message #353998] Thu, 16 October 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you read the Reference manual?
PROCESSES: Range of values: 6 to operating system dependent
SESSIONS: Range of values: 1 to 2^31

Regards
Michel
Re: MAXIMUM sessions and processes [message #354004 is a reply to message #353998] Thu, 16 October 2008 01:10 Go to previous messageGo to next message
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
Member
so to connect concurrent user which parameter should i increase?
Re: MAXIMUM sessions and processes [message #354008 is a reply to message #354004] Thu, 16 October 2008 01:17 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Read Concept manual.

you will get your answer.

http://tahiti.oracle.com ---"CONCEPT GUIDE"
Re: MAXIMUM sessions and processes [message #354056 is a reply to message #353998] Thu, 16 October 2008 04:44 Go to previous messageGo to next message
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
Member
Hi

I want to know what is the Maximum limit for processes and sessions in oracle 10g enterprise edition?

i want to make 5000 concurrent connection on one user?
WHAT ARE THE PARAMETERS TO SET?


so can any one give me the steps for this?


please help me.........

thanks
Re: MAXIMUM sessions and processes [message #354063 is a reply to message #354056] Thu, 16 October 2008 05:18 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I want to know what is the Maximum limit for processes and sessions in oracle 10g enterprise edition?


Michel Cadot wrote on Thu, 16 October 2008 07:59
Did you read the Reference manual?
PROCESSES: Range of values: 6 to operating system dependent
SESSIONS: Range of values: 1 to 2^31


Quote:
WHAT ARE THE PARAMETERS TO SET?

What you want beyond the limits.

Regards
Michel

Previous Topic: what is server PSEUDO?
Next Topic: internal error, conection to the server failed
Goto Forum:
  


Current Time: Fri Nov 29 17:42:49 CST 2024