Tuning IBM AIX 5.3 and AIX 6.1 for Oracle Database
5墨值下载
Tuning IBM AIX 5.3 and AIX 6.1
for Oracle Database
Dennis Massanari, Arun Sar
IBM eServer Solutions Enablement
Lilian Romer o
IBM Power Systems Performance
January 2009
© Copyright IBM Corporation, 2009. All Rights Reserved.
All trademarks or registered trademarks mentioned herein are the propert y of their respective hold ers
Table of contents
Abstract........................................................................................................................................1
Introduction .................................................................................................................................1
Tuning processor performance .................................................................................................1
Simultaneous multithreading .................................................................................................................. 1
Process scheduling and priority.............................................................................................................. 3
Process priority and RAC................................................................................................................. 3
Processor affinity .................................................................................................................................... 4
Processor binding ............................................................................................................................ 5
Resource sets .................................................................................................................................. 5
Logical partitioning and Micro-Partitioning ............................................................................................. 5
Tools to monitor processor performance................................................................................................ 6
The vmstat command....................................................................................................................... 7
The iostat command......................................................................................................................... 8
The sar command ............................................................................................................................ 9
The lparstat command ................................................................................................................... 10
Tuning memory .........................................................................................................................11
Oracle process memory footprint .........................................................................................................11
VMM tuning...........................................................................................................................................12
Multiple-page size support.................................................................................................................... 13
16 MB (large) pages.......................................................................................................................13
64 KB (medium) pages ..................................................................................................................16
Tools to monitor memory usage ........................................................................................................... 18
vmstat............................................................................................................................................. 18
svmon............................................................................................................................................. 19
ps.................................................................................................................................................... 19
pagesize.........................................................................................................................................19
Tuning I/O performance............................................................................................................20
AIX V6.1................................................................................................................................................ 20
Asynchronous I/O ................................................................................................................................. 20
Asynchronous I/O servers.............................................................................................................. 20
maxreqs .........................................................................................................................................23
File system and raw I/O........................................................................................................................23
Raw I/O ..........................................................................................................................................24
pbufs ..............................................................................................................................................24
The lvm_bufcnt command.............................................................................................................. 25
Concurrent I/O................................................................................................................................25
Enhanced journal file system (JFS2) and concurrent I/O .............................................................. 26
GPFS .............................................................................................................................................27
Automated storage management .........................................................................................................27
Tools to monitor I/O performance......................................................................................................... 27
vmstat............................................................................................................................................. 27
iostat............................................................................................................................................... 27
The filemon command....................................................................................................................30
Summary....................................................................................................................................31
Resources..................................................................................................................................32
About the authors .....................................................................................................................34
Trademarks and special notices..............................................................................................35
Tuning IBM AIX 5L V5.3 and AIX 6.1 for Oracle Database on POWER systems
of 37
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论