Home » RDBMS Server » Server Administration » Database server configuration and 4000 concurrent users
Database server configuration and 4000 concurrent users [message #279499] Thu, 08 November 2007 17:20 Go to next message
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!
Re: Database server configuration and 4000 concurrent users [message #279688 is a reply to message #279499] Fri, 09 November 2007 11:04 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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!
Re: Database server configuration and 4000 concurrent users [message #279720 is a reply to message #279688] Fri, 09 November 2007 13:31 Go to previous message
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:
  


Current Time: Tue Dec 06 04:09:56 CST 2016

Total time taken to generate the page: 0.08906 seconds