Agree , 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 substantial. I specified/designed for a Telco a system a while ago where we were looking at Solid state exactly for this reason, George =20________________________________________________ George Leonard Oracle Database Administrator New Dawn Technologies @ Wesbank E-mail:gleonard@xxxxxxxxxxxxx =20 You Have The Obligation to Inform One Honestly of the risk, And As a Person 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! =20 -----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 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. > 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. --=20 Cheers Nuno Souto nsouto@xxxxxxxxxxxxxx -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=3Dunsubscribe=20 To search the archives - //www.freelists.org/archives/oracle-l/ _________________________________________________________________________= __________________________ 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 - //www.freelists.org/archives/oracle-l/