Home » RDBMS Server » Server Administration » DB Server Configuration (Oracle 11g R2, Linux)
DB Server Configuration [message #631197] Sat, 10 January 2015 04:28 Go to next message
ninan
Messages: 163
Registered: June 2011
Location: Noida
Senior Member
Hi,

Building a new application which is expected to have 30 million users.
and each user will make average of 2 searches per visit.
It should support that 20% of the visits will add items to the shopping cart.
And it should support for 15% of the visits will be checked out.
The application should be able to support 1.5 million orders per month.
Of which 10% of the submitted orders are modified.
It should support the average size of 5 item lines per order
Requirement is to store all customer order history for 2 years before purging.

The number of concurrent visits on a busy hour can be 15000 per hour, during high peak shopping seasons.
The user experience is expected such that, item search and display TO sales checkout should not take more than 3 seconds for a user.

What could be a ideal Database server configuration (Oracle 11g R2) required with respect to the Size, Memory and other aspects of the Database, considering all these scenarios, Is a DB of Terabyte size required to meet this.


Thanks,
ninan.
Re: DB Server Configuration [message #631199 is a reply to message #631197] Sat, 10 January 2015 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Is a DB of Terabyte size required to meet this.


You have the model, the tables definition, you have the figures, the number of rows in each table, so just calculate the size it needs to record all them.

Re: DB Server Configuration [message #631212 is a reply to message #631197] Sat, 10 January 2015 07:16 Go to previous messageGo to next message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
I always advise hosting on a cloud server, if you have no idea what capacity you need. To add or remove memory, CPU, and disc in response to demand is a trivial task. It also means that you can out-source all the admin, you get fantastic reliability, and there is zero starup cost. My boss would be happy to give you a quote Smile
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com
Re: DB Server Configuration [message #631218 is a reply to message #631212] Sat, 10 January 2015 09:12 Go to previous message
BlackSwan
Messages: 26203
Registered: January 2009
Location: SoCal
Senior Member
Simulate a load at 1% of values stated above so you can the extrapolate needed capacity to be 100 times greater.
Previous Topic: Oracle 11g R2 - Support/Approach for Multi-tenancy
Next Topic: SYS object related query taking huge time
Goto Forum:
  


Current Time: Sat Oct 20 18:29:32 CDT 2018