Oracle databases in hpux

The Oracle Database on HP Integrity servers

Executive summary............................................................................................................................... 2 Resource management with Oracle and HP-UX........................................................................................ 2 Oracle’s view of CPU resources......................................................................................................... 3 Adding and deleting CPUs................................................................................................................ 3 Hyper-threading and Oracle.............................................................................................................. 4 Parallel query slaves and Dynamic processor resources........................................................................ 5 Oracle memory management and dynamic memory movement ............................................................. 5 Oracle dynamic memory management............................................................................................ 5 Asynchronous I/O and memorymanagement.................................................................................. 7 Two different views of resource management ...................................................................................... 7 Oracle approach ......................................................................................................................... 8 HP-UXapproach........................................................................................................................... 8 Oracle scheduler ............................................................................................................................. 9 HP-UX scheduler............................................................................................................................. 10 Integration between HP-UX workload management and DBRM............................................................ 11 Oracle and ccNUMA......................................................................................................................... 13 SGA and background processes...................................................................................................... 13 Background processes.................................................................................................................... 15 Shadow processes. ........................................................................................................................ 15 Oracle shared servers..................................................................................................................... 15 Parallel queryslaves....................................................................................................................... 15 Oracle ccNUMA and dynamic partitions .......................................................................................... 16 HP-UX 11i v3 special considerations ................................................................................................ 17 HP-UX 11i v2 specialconsiderations ................................................................................................ 18 Tuning a ccNUMA architecture by localizing memory accesses ........................................................... 18 The Database Resource Manager................................................................................................. 18 Tuning with multiplelisteners........................................................................................................ 18 Tuning with a single listener......................................................................................................... 21 Tuning with psets........................................................................................................................ 21 Oracle automatic...