Re: How to store 50 Terabytes per day?
- From: Peter Gram <peter.gram@xxxxxxxxxxxx>
- To: GLeonard@xxxxxxxxxxxxx
- Date: Thu, 09 Sep 2004 18:26:50 +0200
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@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 K Gopalakrishnan
>Sent: 09 September 2004 7:20 AM
>To: ryan_gaffuri@xxxxxxxxxxx; Jared.Still@xxxxxxxxxxx;
>oracle-l@xxxxxxxxxxxxx
>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@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
>>
>>
>
>
>=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@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/
>
>
>
--
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@xxxxxxxxxxxx
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@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
