From oracle-l-bounce@freelists.org Fri Apr 29 14:11:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3TJBUod018800 for ; Fri, 29 Apr 2005 14:11:30 -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 j3TJBQ4Z018792 for ; Fri, 29 Apr 2005 14:11:29 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB98C18A45D; Fri, 29 Apr 2005 13:08:55 -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 20772-01; Fri, 29 Apr 2005 13:08:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D06A189F83; Fri, 29 Apr 2005 13:08:55 -0500 (EST) Message-Id: <200504291806.j3TI6pZ53607@cadre5.com> From: "Vlado Barun" To: , Cc: Subject: RE: Statspack consolidation Date: Fri, 29 Apr 2005 14:06:43 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcVM3E0aRfGl2V9wRkKqa99R6ItgOgACc1hw In-Reply-To: <910046b405042909556f13ca5a@mail.gmail.com> X-archive-position: 19209 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: vlado@cadre5.com Precedence: normal Reply-To: vlado@cadre5.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 Also, you using the table compression feature helps if you are low on free space... Vlado Barun, M.Sc. Senior Data Architect, Cadre5 www.cadre5.com Office: 865 690 4442 Mobile: 865 335 7652 e-mail: vlado@cadre5.com AIM: vbarun2 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Paul Drake Sent: Friday, April 29, 2005 12:55 PM To: daniel.hubler@aurora.org Cc: oracle-l@freelists.org Subject: Re: Statspack consolidation On 4/29/05, daniel.hubler@aurora.org wrote: > We are contemplating creating a single Statpack database, on one > server/instance, > and pushing all of our Statspack data to it. This would probably include > data from 7-8 instances. > We are guessing that we are not the first to consider this. >=20 > Does anyone have any guidelines/comments/horror stories/direction to giv= e > on this idea? >=20 > Any thoughts appreciated! Approach it like supporting rman catalogs: one schema per supported version within the same database, e.g.: perfstat817 perfstat920 perfstat101 you're going to have to disable constraints during import if you use exp/im= p. beware of using direct=3Dy with exp on 10.1.0.3 (bug). partitioning the larger tables would be an excellent idea. perhaps you might even want to export the data as a transportable tablespac= e. I looked at this long ago, but then was cured of CTD so I never completed i= t. Paul --=20 #/etc/init.d/init.cssd stop -- f=3Dma, divide by 1, convert to moles. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l