Oracle 10g Release 2 Performance and Tuning on an IBM System p Linux on POWER Platform

This white paper provides tuning recommendations to improve Oracle 10g Release 2 performance of Linux® on POWER™ to take advantage of the IBM POWER5™ and POWER5+™ processors including Red Hat’s RHEL5 new support for the POWER5+ 64 KB hardware page feature. Illustrated is how essential it is to configuring the SGA to use 16 MB huge pages when using a system with large SGAs. The paper recommends using the NOOP scheduler and demonstrates how to implement adapter tunings to reduce system interrupts. Instructions are also provided on how to bind Oracle processes to CPUs and how to set process priorities to provide additional gains.

Presented is how to link an Oracle executable with libhugetlbfs to gain performance under an OLTP workload. A very noticeable performance gain of 6% using huge page backed text segment for a Linux kernel using 4 KB pages was observed. This is a significant gain when you consider that libhugetlbfs does not require access or changes to the application source code. However, it is not recommend to use huge page data segment for OLTP–like workload due to excessive local and remote memory accesses.

Use of the latest Oracle 10g Release 2 patch set is recommended. This is certified on RHEL5 and includes the most recent Oracle performance features.

In addition, the paper provides a proof point between a 4–core and 8-core system that Oracle 10g Release 2 is capable of scaling vertically by at least 80%.

Contact an IBM Sales Specialist

Browse Power Systems

Next generation applications for big data and analytics and cognitive computing are providing unprecedented insights into opportunities, threats and efficiencies. IBM Power Systems is at the forefront of delivering solutions to gain faster insights from analyzing both structured information and unstructured big data. With the secure, flexible and open platform of IBM Power Systems plus solutions and software, organizations can outpace their competitors by delivering faster services, providing differentiated offerings and turning operational cost into investment opportunity.

To draw insights and make better decisions, businesses rely on the secure, flexible and open platform of IBM Power Systems. Built with the first processor designed for big data workloads, the design of Power Systems combines the computing power, memory bandwidth and I/O in ways that are easier to consume and manage, building on strong resiliency, availability and security.

IBM Power Systems deliver flexibility and choice of operating systems to enable your business to support the next generation applications for big data and analytics and cognitive computing that are transforming how organizations work today. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

Transform your business with Systems Software that enables virtualization, high availability, flexibility, security and compliance on Power Systems™. IBM’s integrated approach to developing Systems and Systems Software together delivers optimized results with Power Systems.

As an open innovation platform, Power Systems is optimized for big data and analytics performance and to deliver scale-out economics and security for the cloud. IBM and IBM Business Partner solutions exploit key capabilities in IBM Power Systems.

Over the last five years thousands of clients have migrated to IBM Power Systems for choice and flexibility. Learn how Power Systems has helped them revolutionize the way IT is developed and delivered, optimize for big data and analytics, and support private, public and hybrid offerings for scale-out or scale-up implementations all while improving business performance, reducing risk, and establishing a platform for growth.

Full text white paper