From oracle-l-bounce@freelists.org Thu Sep 9 11:24:33 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i89GOX408165 for ; Thu, 9 Sep 2004 11:24:33 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i89GOXI08159 for ; Thu, 9 Sep 2004 11:24:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB42172C753; Thu, 9 Sep 2004 11:24:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02870-89; Thu, 9 Sep 2004 11:24:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53D6F72D95F; Thu, 9 Sep 2004 11:24:21 -0500 (EST) Message-ID: <4140844A.2000502@miracleas.dk> Date: Thu, 09 Sep 2004 18:26:50 +0200 From: Peter Gram Organization: Miracle A/S User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: GLeonard@wesbank.co.za Cc: oracle-l@freelists.org Subject: Re: How to store 50 Terabytes per day? References: <1831A554E8800049B6B970790D2513C035C0D2@fnbkrkmx01.fnb.co.za> In-Reply-To: <1831A554E8800049B6B970790D2513C035C0D2@fnbkrkmx01.fnb.co.za> Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 9322 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.gram@miracleas.dk Precedence: normal Reply-To: peter.gram@miracleas.dk X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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@freelists.org >[mailto:oracle-l-bounce@freelists.org] On Behalf Of K Gopalakrishnan >Sent: 09 September 2004 7:20 AM >To: ryan_gaffuri@comcast.net; Jared.Still@radisys.com; >oracle-l@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@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@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@freelists.org&subject=unsubscribe >To search the archives - http://www.freelists.org/archives/oracle-l/ > > > -- Best regards / Venlig hilsen /*Peter Gram*/ Miracle A/S 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@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 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@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/