SPAM Performance

[Former Member]

Hi all, i just upgrade s ystem from 4.7 to ECC6 , its on AIX with oracle 10.0.2 .

i notice the spam take very long time to run

to run this import queue, it take more than 6 hours

SAPKB70012

SAPKA70012

SAPKIPYJ7C

SAPKW70013

SAPKNA7009

SAPKH60009

SAPKH60010

topas to monitor OS performance also did not show anything :

EVENTS/QUEUES FILE/TTY

Wed Jan 16 11:12:41 2008 Interval: 2 Cswitch 6088 Readch 558.7K

Syscall 16633 Writech 417.3K

Kernel 4.6 |## | Reads 2909 Rawin 0

User 42.2 |############# | Writes 2984 Ttyout 170

Wait 2.8 |# | Forks 0 Igets 1

Idle 50.4 |############### | Execs 0 Namei 25

Runqueue 0.5 Dirblk 5

Network KBPS I-Pack O-Pack KB-In KB-Out Waitqueue 0.5

lo0 1059.2 2821.3 2821.3 529.6 529.6

en0 0.9 9.9 1.0 0.7 0.3 PAGING MEMORY

en1 0.0 0.0 0.0 0.0 0.0 Faults 43 Real,MB 7792

Steals 0 % Comp 67.7

Disk Busy% KBPS TPS KB-Read KB-Writ PgspIn 0 % Noncomp 33.1

dac0 0.0 107.2 13.4 95.3 11.9 PgspOut 0 % Client 33.1

hdisk8 0.0 59.6 7.4 59.6 0.0 PageIn 27

hdisk3 0.0 31.8 4.0 31.8 0.0 PageOut 4 PAGING SPACE

Sios 31 Size,MB 20480

Name PID CPU% PgSp Owner % Used 0.6

oracle 929902 42.6 6.6 orat01 NFS (calls/sec) % Free 99.3

R3trans 897100 6.0 23.7 t01adm ServerV2 0

topas 708622 0.4 1.8 root ClientV2 0 Press:

nmbd 282762 0.0 0.8 root ServerV3 0 "h" for help

java.bin 958516 0.0 44.2 orat01 ClientV3 0 "q" to quit

and there is 1 R3trans running

R3trans -w /usr/sap/trans/tmp/SAPIB70012.T01 /usr/sap/trans/tmp/SAPKKB70012.T01

Any idea how to improve it ? because i have another system on AIX but using DB2, it having less memory and cpu , still faster when doing SPAM

[former_member185954]

Hi,

After upgrade, before running patches its always advisable to run Tablespace REORG.

Regards,

Siddhesh