Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need to Log on 2000 users

RE: Need to Log on 2000 users

From: QuijadaReina, Julio C <QuijadJC_at_alfredstate.edu>
Date: Fri, 30 May 2003 08:55:04 -0800
Message-ID: <F001.005A7001.20030530085504@fatcity.com>


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: 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: QuijadaReina, Julio C
  INET: QuijadJC_at_alfredstate.edu

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).
Received on Fri May 30 2003 - 11:55:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US