RE: Need to Log on 2000 users

Munish - Don't forget to change the init.ora parameter PROCESSES greater than 2000. I didn't see where anyone mentioned that.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, May 30, 2003 4:15 AM
To: Multiple recipients of list ORACLE-L

You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server.

You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down.

This seems like a silly exercise. Whose idea is it?

"Good luck with all that"

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 29 May 2003, Munish Bajaj wrote:



> Hi Gurus,

> 

> I am facing a problem. I need to log on 2000 users to my database via

> dedicated server connection on Oracle 9iR2 running on Windows 2000

Advanced


> server. 

> 

> Please guide me as to what all parameters need to be tuned to achieve the

> same. 

> 

> The Server is a single CPU server with 3G RAM.

> 

> I need just to logon 2000 users. This is a load test that I need to

perform.


> 

> Thanks to all

> 

> Regards 

> Munish Bajaj 

> 

> 

> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).