Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Infrastructure Question: setup a 100TB database/data center

user8604530Jul 14 2010 — edited Jul 15 2010
Hi guys,

Looking for your guideline and assistance, in setting up, this big environment, these numbers are not accurate, but just to give some idea, I'll mention, which are the correct numbers (correct).

The environment is an Oracle/Linux, but no VMWare.

250,000 transactions/day (*correct*) - at least for 1 year => 260 (working days in 2010) * 250000 = 65,000,000.00

Each transaction size will be, max = 2mb

2mb * 250,000 = 500,000 mb or .5 tb (approx) per day data will be coming to our data center

98% it'll be Inserts only

the rest can be divided into SELECT or UPDATE, almost no DELETE at all.

What I'm looking for, some guideline, assistance & help, in taking up this task and proceeding and forwarding in the right direction.

Will highly appreciate your help & guidance.

Best regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2010
Added on Jul 14 2010
1 comment
790 views