Installation guide
2
Executive summary
The HP Scalable Warehouse Solution for Oracle on Hewlett-Packard (HP) servers, storage and networking products
provides a prescriptive approach for balancing server, storage, network and software configurations for architecting
Oracle data warehouse solutions. The reference architectures provide server and storage guidance for various data
warehouse workloads – giving you the most efficient configuration for your solution, saving you time and cost in
choosing the right technology, and giving you peace of mind that the right platform and architecture is in place.
Target audience: The target audience for this document consists of IT planners, architects, system administrators,
DBAs, CIOs, CTOs, and business intelligence (BI) users with an interest in options for their BI applications and in the
factors that affect those options.
This white paper describes testing performed in May-September 2011.
If you need help with a specific Oracle solution or prefer a solution design or sizing based on your requirements
please contact your local HP reseller, HP sales representative, or the HP Oracle Solution Center in your region.
Introduction
This document is a reference configuration for the HP Scalable Warehouse Solution for Oracle, which describes a
repeatable architectural approach for implementing a scalable model for a symmetric multiprocessor (SMP)-based
Oracle data warehouse. The end result of the process described in this guide represents a recommended minimal
Oracle database configuration, inclusive of all the software and hardware, required to achieve and maintain a
baseline level of “out of box” scalable performance when deploying Oracle data warehousing sequential data access
workload scenarios versus traditional OLTP random I/O methods.
This document provides specific details about the testing, configuration and bill of materials for such reference
architecture, based on the HP ProLiant DL980 G7 and the HP P2000 G3 Modular Smart Array (P2000 G3 MSA).
This configuration is targeted at a data warehouse / data mart environment with scan rate requirements of
18GB/sec. It is optimized at 19TB of usable user data (RAW) capacity.
Some attributes of this solution includes:
Single scale up or multiple scale out server database applications
High sustained sequential read I/O throughput (high performance)
High Availability storage redundancy
Server redundancy (through Oracle Data Guard or Real Application Cluster)
Large capacities of usable storage
Performance scalable solution
HP Scalable Warehouse Solution for Oracle:
Delivering leading headroom and expandability for x86 virtualization and enterprise applications
Efficiently use compute resources with HP’s market leading 8 socket architecture
– Smarter CPU caching strategy, improves CPU utilization and performance
– Flexible expansion of CPU, memory and I/O capacity to grow with your needs
– Single 8 processor server to multiple server growth path to support large database environments
Faster design to implementation, with HP and key industry partner solution stacks extended to address scale-up x86
environments
– Collaborative partnerships: Microsoft®, Red Hat, SUSE, Oracle and VMware
– Operating system and virtualization software enhanced to support large scale-up x86 environments
– HP Management software to help reduce and manage complexity
– HP consulting services for implementing BI strategies
Speed your way to better business outcomes with
– HP’s in-depth Solution and Services expertise
– HP’s broad portfolio of complementary products