IBM WEBSPHERE 6.1.X - Manual (Page 25)

2 0
W E B S P H E R E P O R T A L V 6 . 1 T U N I N G G U I D E
O R A C L E O N A I X S E T U P
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
O R A C L E E N T E R P R I S E E D I T I O N D A T A B A S E P A R A M E T E R T U N I N G
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