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
∙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
∙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 | |