OraFAQ Forum: Server Administration » Database server configuration and 4000 concurrent users

Home » RDBMS Server » Server Administration » Database server configuration and 4000 concurrent users

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database server configuration and 4000 concurrent users [message #279499]

Thu, 08 November 2007 17:20

syang
Messages: 30
Registered: February 2007

Member

Hi All,

Can someone point me to some reference/resources in regard to configure Oracle database server to handle 4,000 to 5,000 concurrent users? Any benchmarks?

The system will be OLTP performing bidding transactions.

We will greatly appreciate if you could share your experience and knowledge in this area.

Thanks!

Report message to a moderator

Re: Database server configuration and 4000 concurrent users [message #279688 is a reply to message #279499]

Fri, 09 November 2007 11:04

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Every one have different situations.Well it depends on the work nature for 3000/4000 users whether they gonna do all
DMLs or whether some of them will do DMLs and rest of them access the database for reporting purposes,
and it also depend on the sizes of objects which gonna be access.

No one can predict without such a information.

[Updated on: Fri, 09 November 2007 11:05]

Report message to a moderator

Re: Database server configuration and 4000 concurrent users [message #279719 is a reply to message #279688]

Fri, 09 November 2007 13:25

syang
Messages: 30
Registered: February 2007

Member

The bidding system we are going to build will have 40,000 registered bidders (users). We anticipate 4,000 users could hit the system concurrently. The user transactions will be mainly DML (select, insert, update, and delete). No reports during the bidding period. Most of the tables will not be large in size (less than 2 GB).

SunOS 5.9
Oracle 10g r2
Websphere application server

We are concerned about the 4,000 concurrent users hitting the database at the same time. Wondering if anyone can share their experience and lessons learned if you have done similar configuration on the database side as well as on the WAS side.

Thanks!

Report message to a moderator

Re: Database server configuration and 4000 concurrent users [message #279720 is a reply to message #279688]

Fri, 09 November 2007 13:31

andrew again
Messages: 2577
Registered: March 2000

Senior Member

I'd start by translating your "4-5000 concurrent users" into:
1.) number of concurrent database sessions
2.) max number of these OLTP transactions per minute

If you have a web interface, concurrent users almost certainly doesn't translate to concurrent database sessions. Additionally, if you use connection pooling, that changes the number of concurrent sessions too. The rate of transaction is important, as well as how much workload a transaction involves.

Check on asktom.oracle.com for "connection pooling" and "shared server" (MTS) mode. Don't use is without good reason - it's essentially the same as connection pooling.

[Updated on: Fri, 09 November 2007 13:33]

Report message to a moderator

Previous Topic:	Can't initialize OCI
Next Topic:	Reading from a control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:15:22 CDT 2024