RE: How to store 50 Terabytes per day?

  • From: "Leonard, George" <GLeonard@xxxxxxxxxxxxx>
  • To: <nsouto@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Sep 2004 10:22:23 +0200


, the only issue with this is normally budget but when you plan on
storing this amount of data then I am guessing budget is likewise

I specified/designed for a Telco a system a while ago where we were
looking at Solid state exactly for this reason,

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 Nuno Pinto do Souto
Sent: 09 September 2004 7:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: How to store 50 Terabytes per day?

Quoting from AUTHOR: Leonard, George:

> 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
> 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.
> snip
> 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.

One solution: SSD.  Solid-State-Disk.  They have some amazing
write rates.  Much faster than anything a traditional disk can do.
And they have their own power backup and offline storage to disk.
Saw one demo a couple of years ago, the guy was writing 5 million
rows in a matter of a few short seconds.  Capacity is not large
enough for datafiles but is plenty for redo.

Nuno Souto

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: