From oracle-l-bounce@freelists.org Wed Jan 12 10:00:54 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0CG0s729237 for ; Wed, 12 Jan 2005 10:00:54 -0600 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 j0CG0sn29232 for ; Wed, 12 Jan 2005 10:00:54 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E70272C7CB; Wed, 12 Jan 2005 11:07:30 -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 17600-22; Wed, 12 Jan 2005 11:07:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D2A8472C5CF; Wed, 12 Jan 2005 11:03:06 -0500 (EST) X-IronPort-AV: i="3.88,118,1102309200"; d="scan'208"; a="155162860:sNHT17571360" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Content-Class: urn:content-classes:message MIME-Version: 1.0 Priority: normal Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: SuperDome and VPARS Date: Wed, 12 Jan 2005 10:54:17 -0500 Message-ID: <52C70FF150F49E479DAF59C68A27149DAFC881@va016a0e2.corp.suntrust.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SuperDome and VPARS thread-index: AcT352lVXGB5Duo4R7yxpUOYs1TkzAA1laaA From: "Kline.Michael" To: X-OriginalArrivalTime: 12 Jan 2005 15:54:17.0374 (UTC) FILETIME=[F8BBABE0:01C4F8BE] X-archive-position: 14695 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Michael.Kline@SunTrust.com Precedence: normal Reply-To: Michael.Kline@SunTrust.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Got no hits on this. I take it there aren't too many using SuperDome, or never played much with splitting out the VPARS and comparing results. Michael Kline > -----Original Message----- > > We've got two data warehouses that we are going to migrate. Here were > some of the thoughts. I was wondering if anyone had the luxury of > testing BOTH ways and what they found out. NORMALLY the PRD database > builds a bunch of data which this then transferred to RPT for reporting, > so one is active and then the other, but both COULD be active at the > same time. These are almost 2TB each, so not that big. The application > NORMALLY shows signs of being I/O bound more than anything else due to > the size of the data. > > > Anyone "Been there, done that???" > > > > I'm sort of inclined to keep the current way, one VPAR. > > > > "I am sorry I have not been paying a much attention to the configuration > as I should, but I want to make a suggestion. The Superdome resources > for XXXXX appear to be 8 CPUs, 16 GB memory and 8 SAN cards. As I > understand, the current plan is to create two VPARS that have two > permanently assigned CPU's and the ability to acquire up to 4 'floating' > CPUs. Each would have a static amount of memory and each would have 4 > SAN cards. I would suggest we put all of these resources into one vpar. > That way the two instances, pfrpt, pfprd would have full access to ALL > resources. This could improve I/O throughput, as well as provide more > combined memory and CPU power that two separate partitions. I don't > know about the other software systems (People tools, informatica), but > this seems like a superior configuration than two vpars who will have > unused computer resources at different times. What do you think?" > > > > Michael Kline > Database Administration > SunTrust Technology Center > 1030 Wilmer Avenue > Richmond, Virginia 23227 > Outside 804.261.9446 > STNet 643.9446 > > Cell 804.744.1545 ************************************************ The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. ************************************************ -- http://www.freelists.org/webpage/oracle-l