Oracle

Summary
On HP-UX Itanium Superdome after the upgrade to 10.2.0.4 Oracle automatically stopped using all the cells and from 5 cells uses only the first cell. That had as a result from the 40 cpus of the server, oracle to uses only the first 8.

The upgrade to Oracle 10.2.0.4 automatically changed the initialization parameters to:

_enable_numa_optimization=TRUE
_db_block_numa=5

SELECT * FROM (
SELECT a.ksppinm AS parameter,
       a.ksppdesc AS description,
       b.ksppstvl AS session_value,
       c.ksppstvl AS instance_value
FROM   x$ksppi a,
       x$ksppcv b,
       x$ksppsv c
WHERE  a.indx = b.indx
AND    a.indx = c.indx
AND    a.ksppinm LIKE '/_%' ESCAPE '/'
ORDER BY a.ksppinm) 
WHERE parameter IN ('_enable_NUMA_optimization', '_db_block_numa')

PARAMETER                                DESCRIPTION                              SESSION_VALUE  INSTANCE_VALUE
---------------------------------------- ---------------------------------------- -------------- ---
_db_block_numa                           Number of NUMA nodes                     1              1
_enable_NUMA_optimization                Enable NUMA specific optimizations       FALSE          FALSE

alter system set "_enable_NUMA_optimization" = FALSE scope = spfile;
alter system set "_db_block_numa" = 1 scope = spfile;