Oracle Architecture and Tuning on AIX (v 2.30)
5墨值下载
IBM Americas Advanced Technical Support
© 2011 International Business Machines, Inc.
I
I
B
B
M
M
O
O
r
r
a
a
c
c
l
l
e
e
T
T
e
e
c
c
h
h
n
n
i
i
c
c
a
a
l
l
B
B
r
r
i
i
e
e
f
f
O
O
r
r
a
a
c
c
l
l
e
e
A
A
r
r
c
c
h
h
i
i
t
t
e
e
c
c
t
t
u
u
r
r
e
e
a
a
n
n
d
d
T
T
u
u
n
n
i
i
n
n
g
g
o
o
n
n
A
A
I
I
X
X
D
D
a
a
m
m
i
i
r
r
R
R
u
u
b
b
i
i
c
c
I
I
B
B
M
M
S
S
A
A
P
P
&
&
O
O
r
r
a
a
c
c
l
l
e
e
S
S
o
o
l
l
u
u
t
t
i
i
o
o
n
n
s
s
A
A
d
d
v
v
a
a
n
n
c
c
e
e
d
d
T
T
e
e
c
c
h
h
n
n
i
i
c
c
a
a
l
l
S
S
k
k
i
i
l
l
l
l
s
s
V
V
e
e
r
r
s
s
i
i
o
o
n
n
:
:
2
2
.
.
3
3
0
0
D
D
a
a
t
t
e
e
:
:
0
0
8
8
O
O
c
c
t
t
o
o
b
b
e
e
r
r
2
2
0
0
1
1
2
2
IBM Americas Advanced Technical Support
© 2011 International Business Machines, Inc.
Page 2
ACKNOWLEDGEMENTS ........................................................................................................................ 5
• DISCLAIMERS ...................................................................................................................................... 5
• TRADEMARKS ..................................................................................................................................... 5
• FEEDBACK .......................................................................................................................................... 6
• VERSION UPDATES .............................................................................................................................. 6
INTRODUCTION........................................................................................................................................ 7
1. ORACLE DATABASE ARCHITECTURE ...................................................................................... 8
1.1. DATABASE STRUCTURE .................................................................................................................. 8
1.1.1. Logical Structure ................................................................................................................... 8
1.1.2. Physical storage structures .................................................................................................. 10
1.2. INSTANCE AND APPLICATION PROCESSES ..................................................................................... 12
1.3. ORACLE MEMO RY STRUCTURES .................................................................................................... 19
2. AIX CONFIGURATION & TUNING FOR ORACLE ................................................................. 22
2.1. OVERVIEW OF THE AIX VIRTUAL MEMORY MANAGER (VMM) .................................................. 22
2.1.1. Real-Memory Management .................................................................................................. 22
2.1.2. Persistent versus Working Segments ................................................................................... 23
2.1.3. Computational versus File Memory..................................................................................... 25
2.1.4. Page Replacement ................................................................................................................ 25
2.2. MEMORY AND PAGING .................................................................................................................. 27
2.2.1. AIX 6.1 and 7.1 Restricted Tunables concept ...................................................................... 27
2.2.2. AIX free memory .................................................................................................................. 27
2.2.3. AIX file system cache size .................................................................................................... 28
2.2.4. Allocating sufficient paging space ....................................................................................... 32
2.2.5. AIX Multi-page size support for Oracle & SGA Pinning .................................................... 32
2.2.6. AIX 1TB Segment Aliasing ................................................................................................... 35
2.2.7. AIX Kernel Memory Pinning ............................................................................................... 37
2.2.8. AIX Enhanced Memory Affinity ........................................................................................... 38
2.3. I/O CONFIGURATION ..................................................................................................................... 42
2.3.1. AIX LVM - Volume Groups .................................................................................................. 42
2.3.2. AIX LVM - Logical Volumes ................................................................................................ 42
2.3.3. AIX sequential read ahead ................................................................................................... 44
2.3.4. I/O Buffer Tuning ................................................................................................................. 45
2.3.5. Disk I/O Tuning.................................................................................................................... 47
2.3.6. Disk I/O Pacing.................................................................................................................... 54
2.3.7. Asynchronous I/O................................................................................................................. 55
2.3.8. JFS2 file system DIO/CIO mount options ............................................................................ 58
2.3.9. Oracle ASM & AIX Considerations ..................................................................................... 61
2.4. CPU TUNING ................................................................................................................................ 65
2.4.1. Simultaneous Multi-Threading (SMT) ................................................................................. 66
2.4.2. Logical Partitioning ............................................................................................................. 67
2.4.3. Micro-Partitioning ............................................................................................................... 67
2.4.4. Virtual Processor Folding ................................................................................................... 69
2.5. NETWORK TUNING ........................................................................................................................ 71
of 79
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论