IBM 6.1.X Mount -o cio /u02, chdev -l sys0 -a maxuproc=’4096’, sessions, sgatarget, processes

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
	2 0
	W E BS P HE R E P O R T AL V 6 . 1 T U N I N G G U I D E