188 POWER7 and POWER7+ 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 Ye s Ye s
strict_maxperm Ye s Ye s
lru_file_repage Ye s 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 Ye s Ye s
memory_affinity Ye s Ye s
v_pinshm No No
lgpg_regions No No
lgpg_size No No
To Next Page
Loading...
