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.

Report message to a moderator

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.

Report message to a moderator

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 !

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:43:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.