Home » RDBMS Server » Server Administration » QUESTION ABOUT MAX NUMBER OF ORACLE THREADS IN 64-BIT W2003
QUESTION ABOUT MAX NUMBER OF ORACLE THREADS IN 64-BIT W2003 [message #201681] Mon, 06 November 2006 06:21 Go to next message
suvv
Messages: 17
Registered: October 2006
Junior Member

If the database is running in dedicated server mode, what is the limit to the number of sessions (threads) on a 64-bit Windows 2003 server? Is there a ceiling to the number of sessions that I think relates to the number of threads in the oracle.exe?

Evaluating the difference between shared and dedicated server.

Current impletation of software opens up to 20 sessions per user in dedicated mode.



Re: QUESTION ABOUT MAX NUMBER OF ORACLE THREADS IN 64-BIT W2003 [message #201682 is a reply to message #201681] Mon, 06 November 2006 06:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
In a shared server environment, the value of PROCESSES can be quite small. Therefore, Oracle recommends that you adjust the value of SESSIONS to approximately 1.1 * total number of connections.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams190.htm

hope this helps
Mohammad Taj.


Re: QUESTION ABOUT MAX NUMBER OF ORACLE THREADS IN 64-BIT W2003 [message #201685 is a reply to message #201681] Mon, 06 November 2006 06:37 Go to previous message
suvv
Messages: 17
Registered: October 2006
Junior Member
Thanks Mohammad.

But my question was

**If the database is running in dedicated server mode, what is the limit to the number of sessions (threads) on a 64-bit Windows 2003 server?

**Is there a ceiling to the number of sessions that I think relates to the number of threads in the oracle.exe?

Thanks !
Previous Topic: ORA-03106 fatal two-task communication protocol error
Next Topic: export is too slow
Goto Forum:
  


Current Time: Thu Dec 08 17:59:40 CST 2016

Total time taken to generate the page: 0.13058 seconds