Filter
Top Products
20
WEBSPHERE PORTAL V6.1 TUNING GUIDE
OR ACLE O N AIX SETUP
We configure our Oracle database on AIX using the following setup,
• Set the filesystem which will hold the Portal databases to be a Enhanced
Journal File System (JFS2).
• Turn on concurrent I/O (CIO) for database filesystem as this improves
performance. Do not enable CIO for Oracle product filesystem, ie, /u01, as
Oracle could fail to start.
To enable CIO, use the following command to mount the database fileset.
Mount –o cio /u02
• Increase AIX maximum number of processes per user to 4096.
The default 500 processes per user is too low for database server, we increase
it to 4096 in our AIX environment. To increase it,
chdev –l sys0 –a maxuproc=’4096’
• Enable AIX async I/O, and increase MinServer to 5.
smitty aio Change/Show Characteristics of Async I/O
MinServers = 5
• We also set in oracle user’s profile as Oracle Installation Guide for AIX
recommends,
AIXTHREAD_SCOPE=S
OR ACLE EN TERPRISE EDI TION D ATABASE PARAMETER TUNI NG
Database performance is very important for obtaining good performance from WebSphere
Portal. Below is a list of tuning applied on our Oracle database server with the alter system
command. Additional database tuning maybe needed in your production environments. For
further information on Oracle database tuning, refer to Oracle Performance Tuning Guide at
http://www.oracle.com/technology/documentation/database10g.html
.
Command used:
Alter system set <parameter> scope=spfile;
Table 8: Oracle Database Tuning
Parameter Value
sessions
900
sga_target
1813M
pga_aggregate_target
604M
processes
750
open_cursors
1500
db_files
1024