Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SuperDome and VPARS

SuperDome and VPARS

From: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Tue, 11 Jan 2005 09:14:44 -0500
Message-ID: <52C70FF150F49E479DAF59C68A27149DAFC819@va016a0e2.corp.suntrust.com>


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
 <mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com



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
Received on Tue Jan 11 2005 - 08:15:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US