Re: Need to Log on 2000 users

D'oh!

I was thinking 8i. My mind hasn't really gotten into 9i mode yet.

pga_aggregate_target is indeed the way to allocate PGA memory.

Jared

Richard Foote <richard.foote_at_bigpond.com> Sent by: root_at_fatcity.com
 05/30/2003 08:54 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: Need to Log on 2000 users

As well as using orastack, go a few steps further and tune the SGA to buggery (make it lean but keen) and set as high a pga_aggregate_target as possible and you might make it (depending on what the 2000 users are doing and depending on how many of them are doing what they're doing concurrently).

As previously suggested, shared servers could be a goer but if dedicated is
a must, consider the above.

Cheers

Richard
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, May 31, 2003 12:54 AM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  INET: richard.foote_at_bigpond.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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.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).