![IBM Power System POWER7 Series Скачать руководство пользователя страница 204](http://html2.mh-extra.com/html/ibm/power-system-power7-series/power-system-power7-series_optimization-and-tuning-manual_3363642204.webp)
188
POWER7 and Optimization and Tuning Guide
Oracle 11gR2 preferred practices for AIX V6.1 and AIX V7.1 on Power Systems
This section is a summary of preferred practices for stand-alone Oracle 11gR2 instances on
AIX V6.1 and AIX 7.1 on POWER7 Systems. Except for references to symmetric
multithreading, quad-threaded mode (SMT4 mode), all of the preferred practices apply to
POWER6 as well. Although the primary focus is on stand-alone Oracle 11gR2 with file
system-based storage, stand-alone ASM is also addressed. These preferred practices apply
to Oracle 10.2.0.4 as well, and where they differ from those practices for Oracle 11gR2,
patches specific to Oracle 10.2.0.4 are noted.
Detailed Oracle/AIX preferred practices documents are available on IBM Techdocs at
http://www.ibm.com/support/techdocs/atsmastr.nsf/Web/Techdocs
, including Oracle
Architecture and Tuning on AIX v2.20, found at:
http://www.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100883
The following sections describe memory, CPU, I/O, network, and miscellaneous settings. In
addition, these sections list the AIX levels that are required for Oracle 11gR2, the Oracle
patches for 11gR2 on AIX V6.1 and AIX V7.1, and the Oracle patches for 10.2.0.4
and 11gR2.
Memory
The specifications for kernel settings and Oracle large page usage are described in the
following sections.
Kernel settings
Kernel settings are listed in Table C-2. These values are commonly suggested ones.
Table C-2 Kernel settings for Oracle
Parameter
Proposed
value
AIX V6.1
default
AIX V6.1
restricted
AIX V7.1
default
AIX V7.1
restricted
minperm%
No
No
maxperm%
90
90
Yes
90
Yes
maxclient%
90
90
Yes
90
Yes
strict_maxclient
Yes
Yes
strict_maxperm
Yes
Yes
lru_file_repage
Yes
N/A
N/A
lru_poll_interval
10
10
Yes
10
Yes
minfree
960
960
No
960
No
maxfree
1088
1088
No
1088
No
page_steal_method
Yes
Yes
memory_affinity
Yes
Yes
v_pinshm
No
No
lgpg_regions
No
No
lgpg_size
No
No
Содержание Power System POWER7 Series
Страница 2: ......
Страница 36: ...20 POWER7 and POWER7 Optimization and Tuning Guide...
Страница 70: ...54 POWER7 and POWER7 Optimization and Tuning Guide...
Страница 112: ...96 POWER7 and POWER7 Optimization and Tuning Guide...
Страница 140: ...124 POWER7 and POWER7 Optimization and Tuning Guide...
Страница 162: ...146 POWER7 and POWER7 Optimization and Tuning Guide...
Страница 170: ...154 POWER7 and POWER7 Optimization and Tuning Guide...
Страница 222: ...POWER7 and POWER7 Optimization and Tuning Guide POWER7 and POWER7 Optimization and Tuning Guide...
Страница 223: ......