Hi all,

We recently installed AIX 5.2 with Oralce 8.1.7.3 on a P690 Dynamic Partitioning system and we experiencing performance problems. Oracle seems to wait on I/O transaction. We have more than 1000 client connected to this database.
The system run with 16 procs POWER4+ and with 30 Go RAM. Could anyone help me to setup the I/O parameters.

Here is ou paramaters.

memory_frames = 7340032
pinnable_frames = 7119419
maxfree = 768
minfree = 760
minperm% = 5
minperm = 357575
maxperm% = 10
maxperm = 715153
strict_maxperm = 0
maxpin% = 80
maxpin = 5872026
maxclient% = 10
lrubucket = 131072
defps = 1
nokilluid = 0
numpsblks = 1048576
npskill = 8192
npswarn = 32768
v_pinshm = 0
pta_balance_threshold = 50
pagecoloring = 0
framesets = 2
mempools = 1
lgpg_size = 0
lgpg_regions = 0
num_spec_dataseg = 0
spec_dataseg_int = 0
memory_affinity = 1
htabscale = 0
force_relalias_lite = 0
relalias_percentage = 0
minpgahead = 2
maxpgahead = 8
pd_npages = 65536
maxrandwrt = 0
numclust = 0
numfsbufs = 186
sync_release_ilock = 0
lvm_bufcnt = 9
j2_minPageReadAhead = 2
j2_maxPageReadAhead = 8
j2_nBufferPerPagerDevice = 512
j2_nPagesPerWriteBehindCluster = 32
j2_maxRandomWrite = 0
j2_nRandomCluster = 0
jfs_clread_enabled = 0
jfs_use_read_lock = 1
hd_pvs_opn = 44
hd_pbuf_cnt = 3072
hd_pendqblked = 0
psbufwaitcnt = 269
fsbufwaitcnt = 577432
rfsbufwaitcnt = 0
xpagerbufwaitcnt = 0


Here is a vmstat 1
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
4 4 2590620 3039 0 0 0 362 1178 0 4030 31739 29677 14 10 63 14
4 17 2590628 3078 0 0 0 1631 4308 0 4751 24553 15674 15 21 12 53
7 26 2591029 3056 0 0 0 2813 7227 0 5697 35629 24500 14 15 20 51
7 31 2591203 3046 0 1 0 8344 23540 0 7622 37217 43535 18 8 12 62
3 32 2591429 3048 0 0 0 6387 14515 0 8030 45613 56353 21 8 11 60
6 12 2592326 3043 0 0 0 4229 11149 0 6494 44388 38638 25 12 19 44
7 13 2592801 3023 0 0 0 1092 2220 0 3828 31121 17822 15 29 19 37
9 14 2592849 3020 0 0 0 357 1001 0 3691 22865 14749 25 31 10 34
8 24 2593608 2871 0 0 0 1100 2199 0 4180 30525 16242 17 34 9 40
7 27 2591361 5126 0 0 0 1949 3645 0 4435 30916 26034 18 30 11 40
8 16 2592490 3012 0 0 0 1082 1860 0 5334 35739 36852 21 16 19 44
6 31 2595336 2988 0 0 0 3612 5657 0 4616 30557 24202 18 29 11 41
6 17 2596571 3012 0 0 0 2387 4829 0 4550 29523 45490 21 29 16 34
8 14 2593798 4890 0 0 0 904 2146 0 6052 35451 44689 26 22 11 41
7 28 2593817 4162 0 0 0 0 0 0 4682 28799 38327 24 10 22 44
6 15 2594301 3038 0 0 0 396 1214 0 5012 28951 43610 22 15 20 43
10 17 2594596 2612 0 0 0 676 1062 0 4387 45656 53859 21 28 19 32

Here is a SAR for ALL Processors.
sar -P ALL 1

AIX mrs-db-00001 2 5 0038F51F4C00 02/11/04

09:42:57 cpu %usr %sys %wio %idle
09:42:58 0 10 15 59 16
1 18 18 63 1
2 11 26 59 4
3 9 29 60 2
4 9 44 38 9
5 14 41 42 3
6 3 26 49 22
7 8 17 75 0
8 24 31 26 19
9 39 24 23 15
10 5 54 41 0
11 33 21 32 15
12 18 17 63 2
13 36 13 38 13
14 28 12 42 18
15 11 16 51 22
- 17 25 48 10

Here is a lsps -s
Total Paging Space Percent Used
4096MB 1%


Here is a svmon -G
size inuse free pin virtual
memory 7340032 7334429 5603 221091 2633014
pg space 1048576 8693

work pers clnt lpage
pin 220845 246 0 0
in use 2632579 4701850 0 0


Thanks for your response.

Christophe HUE