From oracle-l-bounce@freelists.org Fri Aug 26 14:09:22 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7QJ9MSA012798 for ; Fri, 26 Aug 2005 14:09:22 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7QJ9HIP012783 for ; Fri, 26 Aug 2005 14:09:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 687DE1E64A8; Fri, 26 Aug 2005 14:09:10 -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 32306-09; Fri, 26 Aug 2005 14:09:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E38781E632E; Fri, 26 Aug 2005 14:09:09 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=b/zX3ht2Z4+YPhqk+pgviqBgOVVxX/c1vah4JewgvOa+1SoWLox7A8qZBrbsvgeAoCJh9N+Qh4VIMSK4lKuXqGQZuS418h3cE/2AXcJ8lkvOk9wUU52ItQfibP9XyeBftJgKowjuFejTAZuku+eAUnHeiQd2pMaGbSzKJcRGMew= Message-ID: Date: Fri, 26 Aug 2005 20:07:18 +0100 From: Jared Still To: Ranko Mosic Subject: Re: Table growth - disk sizing Cc: "Gogala, Mladen" , Christian.Antognini@trivadis.com, tomday2@gmail.com, Oracle-L In-Reply-To: <367369f105082611574696d795@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_89_25889208.1125083238641" References: <367369f105082611574696d795@mail.gmail.com> X-archive-position: 24581 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_89_25889208.1125083238641 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 8/26/05, Ranko Mosic wrote: >=20 > I am using fully loaded system ( data migrated from legacy ) as baseline. >=20 Do you have growth metrics for the legacy system? If so, load the legacy data into the new system. Compare the amount of storage needed to house this data in the legacy system to the amount needed in the new system. Take the rate of growth from the legacy system and apply to the new system. That's about the best shot you have at it. --=20 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_89_25889208.1125083238641 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 8/26/05, Ranko Mosic <ranko.mosic@gmail.com> wrote:
I am using fully loaded system ( data migrated from legacy ) as baseline.


Do you have growth metrics for the legacy system?

If so, load the legacy data into the new system.

Compare the amount of storage needed to house this data
in the legacy system to the amount needed in the new system.

Take the rate of growth from the legacy system and apply
to the new system.

That's about the best shot you have at it.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist<= br>
------=_Part_89_25889208.1125083238641-- -- http://www.freelists.org/webpage/oracle-l