Dynamic Server Resource Allocation with Oracle Database 10g or 11g on an HP-UX ccNUMA-based server

[chuckk281]

Dynamic Server Resource Allocation with Oracle Database 10g or 11g on an HP-UX ccNUMA-based server

Running Oracle Database 10g or 11g on an HP-UX ccNUMA-based server

• Many HP servers are based on a ccNUMA (cache-coherent Non-Uniform Memory Access) architecture; these servers provide optional features which allow programmers to optimize application performance by tailoring their application to the non-uniform nature of the underlying host server. Depending on the application and workload, by taking advantage of these features and reducing higher-latency memory references, modest performance gains can be achieved.

• Starting with release 10g, the Oracle® database includes such NUMA-optimization features; these can be enabled or disabled at database startup time, and they are enabled by default on some Oracle versions, and disabled on others. To be effective, these optimizations require that the server’s memory is allocated mainly to the individual locality domains (cell-local memory or socket-local memory) rather than to the system as a whole (interleaved memory); newer HP ccNUMA servers default to such a configuration, but older ccNUMA servers do not. It is very important for performance reasons that the setting of Oracle’s NUMA optimizations matches the configuration of the server: never rely on the default settings and configurations to produce an optimal result. 

• While the principles of ccNUMA architecture, and the techniques used to optimize an application like Oracle Database to take advantage of NUMA, have not changed in the 18 or so months since we first published our Oracle-on-ccNUMA white paper, a great number of details have changed: we now have non-cell-based ccNUMA servers (whose default NUMA configuration is different than previous Integrity servers), and we now have Oracle Database 11gR2, with new NUMA behaviors.

 Running Oracle Database 10g or 11g on an HP-UX ccNUMA-based server

o    Describes ccNUMA both for HP’s older cell-based servers and the newer blade-based BL8x0 i2 and Superdome2 servers, explains Oracle’s NUMA optimizations under 10gR2, 11gR1, and 11gR2, and describes how to configure both the server and the Oracle database so they’re compatible from a NUMA perspective 

o    Whitepaper

http://h20195.www2.hp.com/V2/GetDocument.aspx?docname=4AA2-4194ENW&cc=us&lc=en