Home » RDBMS Server » Server Administration » Max Concurrent User for Oracle 8i
Max Concurrent User for Oracle 8i [message #51184] Mon, 06 May 2002 08:14 Go to next message
Bee
Messages: 1
Registered: May 2002
Junior Member
What is the maximum concurrent user that Oracle 8i can handle?

Report message to a moderator

Re: Max Concurrent User for Oracle 8i [message #51216 is a reply to message #51184] Tue, 07 May 2002 13:15 Go to previous message
MarkJ
Messages: 17
Registered: July 1999
Junior Member
The max supported by Oracle 8i (without OPS) is 32,767. However, in file initSID.ora you need to set params PROCESSES, SESSIONS, and TRANSACTIONS to values high enough to support the number of concurrent users you want. I.e., if SESSIONS is set to 200 then you can not have more than 200 sessions eventhough Oracle could support another 32,567 users.

Report message to a moderator

Previous Topic: Terminology
Next Topic: Re: How to find who is holding a temp segment in 7.3.4 ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 10:11:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.