Re: How to store 50 Terabytes per day?

Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit
George

Here it RAC could help since the redo logs are local to the RAC instance. :-)

/peter

Leonard, George wrote:

>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
>=20________________________________________________
>George Leonard
>Oracle Database Administrator
>New Dawn Technologies @ Wesbank
>E-mail:gleonard_at_wesbank.co.za
>=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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan
>Sent: 09 September 2004 7:20 AM
>To: ryan_gaffuri_at_comcast.net; Jared.Still_at_radisys.com;
>oracle-l_at_freelists.org
>Subject: Re: How to store 50 Terabytes per day?
>
>Ryan:
>
>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.
>
>
>=20
>--- ryan_gaffuri_at_comcast.net 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
>>
>>
>
>
>=3D=3D=3D=3D=3D
>Have a nice day !!
>------------------------------------------------------------
>Best Regards,
>K Gopalakrishnan,
>Co-Author: Oracle Wait Interface: Oracle Press 2004.
>http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
>
>
>=09
>=09=09
>__________________________________
>Do you Yahoo!?
>New and Improved Yahoo! Mail - 100MB free storage!
>http://promotions.yahoo.com/new_mail=20
>--
>To unsubscribe -
>mailto:oracle-l-request_at_freelists.org&subject=3Dunsubscribe=20
>To search the archives - http://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_at_freelists.org&subject=unsubscribe
>To search the archives - http://www.freelists.org/archives/oracle-l/
>
>
>

-- 

Best regards / Venlig hilsen

/*Peter Gram*/
Miracle A/S <http://www.miracleas.dk>
Kratvej 2
DK - 2760 Måløv

Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Skype:  peter_gram
Email: peter.gram_at_miracleas.dk

 17 Sep 2004  	 DECUS-fest i Pederstrup 
 18-20 Oct 2004  	 RAC-kursus med Jonathan Lewis 
 29 oct 2004  	 Special SQLserver day with Kimberly Tripp at DBF,Lalandia 
 28-30 Oct 2004  	 The Last Database Forum at Lalandia 
<http://miracleas.dk/events/DBF2004/invitation.html> 
 22-24 Nov 2004  	 RMAN-kursus med Tuomas Pystynen 
 17-19 Jan 2005  	 Miracle Master Class with Tim Gorman 
 28 feb - 2.mar 2005  	 Database Master Class with Chris Date 
 2-4 May 2005  	 SQL Server Master Class with Kimberly Tripp 




-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-vcard
-- File: peter.gram.vcf


--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/