Sorry Munish, I misinterpreted your question. But Jared's suggestion is a good one. You can use orastack to set parameters to maximize memory use for your test database. And too, 128Gb sounds like a pretty large number for 2000 users!
Julio -----Original Message----- Sent: Friday, May 30, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Jeremiah, Where do you get 128Gb? For 2000 users that is ~65M per user, which seems like an excessive estimate. While I probably wouldn't want to run 2k users on a single Windows server, I think you could do it for test purposes. Use orastack to reduce the memory per thread to 500k, set small sort_area_size, etc. Don't see why not. Jared On Friday 30 May 2003 02:14, Jeremiah Wilton wrote: > 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: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: QuijadaReina, Julio C INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).