文件名称：Tuning IBM AIX 5L for an Oracle Database.pdf
文件大小：500KB
文件格式：PDF
更新时间：2012-06-01 14:35:14
Oracle IBM
Abstract.......................................................................................................................................1 Introduction................................................................................................................................1 Tuning processor performance.................................................................................................1 Simultaneous multithreading.................................................................................................................1 Process scheduling and priority..............................................................................................................2 Processor affinity...................................................................................................................................3 Logical partitioning and Micro-Partitioning.............................................................................................5 Tools to monitor processor performance................................................................................................6 The vmstat command.......................................................................................................................6 The iostat command........................................................................................................................7 The sar command...........................................................................................................................8 Tuning memory..........................................................................................................................9 Oracle process memory footprint...........................................................................................................9 Pinning memory.....................................................................................................................................9 Example configuration for using pinned SGA................................................................................10 Large page memory............................................................................................................................10 Example configuration for using large pages for the Oracle SGA.................................................11 Example configuration for using large pages for .text and .data...................................................11 Tools to monitor memory usage...........................................................................................................12 vmstat............................................................................................................................................12 svmon............................................................................................................................................13 Tuning I/O performance............................................................................................................14 Asynchronous I/O...............................................................................................................................................................................