RE: How to store 50 Terabytes per day?

  • From: "Leonard, George" <GLeonard@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Sep 2004 07:28:42 +0200

Strangely enough I think the actual data space is not the problem here,

Your problem will be the redo logs, giving them fast enough discs to
keep up with the data coming in and the same for archive logs (space and
speed), having enough space for 1 or 2 days worth and speed t keep up
with the redo log switching, then a big enough tape system to archive
the archive logs and to backup changed blocks.

Thing is to put the total space together is just discs and controllers
and a lot of funky striping sets and to have the cpu power is multiple
HP's running either UX or Linux or maybe a big Dell cluster.

Every time I worked on a high performance system I always seem to run
into redo log writing speed not being sufficient, being the final
bottleneck... but then this all is a factor of the budget size but def
doable I am sure.

George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
You Have The Obligation to Inform One Honestly of the risk, And As a
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of K Gopalakrishnan
Sent: 09 September 2004 7:20 AM
To: ryan_gaffuri@xxxxxxxxxxx; Jared.Still@xxxxxxxxxxx;
Subject: Re: How to store 50 Terabytes per day?


30K DML is very much achievable. Few weeks back, I was involved in a
benchmark excercise for one of the telcos here and the result was 32k
CDRs/seconds. (Each CDR-Call Data Record processing involves 3-4 DMLs).
So your target is very much possible with minimal tuning.

We have used Pro*C and 9iR2 RAC on HP-UX Itanium.

--- ryan_gaffuri@xxxxxxxxxxx wrote:

> does anyone know what the largest database in the world that uses
> oracle is? I heard that CERN was going to use Oracle for a grid? Is
> this accurate? I Thought that was going to 10 Petabytes?
> what about the highest transaction? An oracle instructor said Amazon
> is using Oracle and I would assume that is pretty book.=20
> When we fully deploy we could be looking at 30,000 DML
> statements/minute during peak time plus 60,000 queries. I'm sure
> there are bigger ones than that... Not sure how you compare activity
> in an oltp though.=20

Have a nice day !!
Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004.

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
To unsubscribe -
To search the archives -

The views expressed in this email are, unless otherwise stated, those of =
the author and not those
of the FirstRand Banking Group or its management.  The information in thi=
s e-mail is confidential
and is intended solely for the addressee. Access to this e-mail by anyone=
=20else is unauthorised.=20
If you are not the intended recipient, any disclosure, copying, distribut=
ion or any action taken or=20
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrit=
y of information and data=20
transmitted electronically and to preserve the confidentiality thereof, n=
o liability or=20
responsibility whatsoever is accepted if information or data is, for what=
ever reason, corrupted=20
or does not reach its intended destination.

=20                              ________________________________
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives -

Other related posts: