Tuning IBM AIX 5.3 and AIX 6.1 for Oracle Database
1057
37页
0次
2019-08-09
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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜