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).

Reply via email to