oracle 9i performance issue

[Former Member]

Dear All,

We are recently migrate sap 4.6c /oracle9i/AIX5.3 IBM power 5 to IBM Power 7 server issue is that the report that run around 40 minute it will take more then 6 hour I donu2019t know what is wrong how to tune that server one thing I also done that I used sap profile and oracle database parameter same but no solution , also run table query from sqlplus it is also take too much time

background process DBWR0 and others show following error

• 2011-03-12 14:08:17.653

• SESSION ID:(2.1) 2011-03-12 14:08:17.650

Warning: lio_listio returned EAGAIN

Performance degradation may be seen

and also all work process

please also send me tips to improve sap and oracle performance

regards

rayyan shahid

[Former Member]

I run common topas ( AIX command to show current performance status ) which is show IO on disk0 and desk1 between 95 to 100 %, and also st04 ---> detail view ---> filesystem avg read 9-10

still through oracle performance very slow

please guide me

[Former Member]

Thanks Markus for ur reply

we are migrate from (SAP 4.6c/oracle 9.2.0.5/AIX 5.3 ) from IBM power5 to IBM power7 with sap 4.6c/oracle9.2.0.5/Aix 5.3) but TL12. also IPs and servers name same we just take full backup and restore in new power7 machine.

but where run heavy reports on sap they give very bad performance also when we run from sqlplus.

I cannot see any more error in sap as will as oracle log files

can we run relinkin command and rootpre.sh scripts now

our please give me an idea to improver database perforance

regards

Rayyan

[Former Member]

thankx Juan Reyes and markus for u reply,

Reyes please clarify more in detailed which patches currently oracle version is 9.2.0.5.0

regards

rayyan shahid

[markus_doehr2]

> Reyes please clarify more in detailed which patches currently oracle version is 9.2.0.5.0

Please read the mentioned Oracle metalink article. It tells you exactly what patches you need.

I'd also consider updating to the latest Oracle patchlevel, 9.2.0.5 is VERY old.

Markus

[markus_doehr2]

Are you running 5.3 on Power 7?

If yes, check Oracle metalink 282036.1 whether you're on the necessary TL and ML/SP level.

Markus

[JPReyes]

Wonder if you install the required patches and opatches to your new DB.

Regards

Juan

[former_member524429]

Hi,

Warning: lio_listio returned EAGAIN*
*Performance degradation may be seen

Such warnings can occur if maxreqs or maxservers parameters are set too low at OS level.

Along with the above suggested SAP Note , refer these useful document [Oracle Architecture and Tuning on AIX|http://www-03.ibm.com/support/techdocs/atsmastr.nsf/5cb5ed706d254a8186256c71006d2e0a/bae31a51a00fa0018625721f00268dc4/$FILE/Oracle%20Architecture%20and%20Tuning%20on%20AIX%20%28v%202.0%29.pdf]. to get more detailed information on some other required configuration settings at ORACLE level as well as on AIX OS level.

Regards,

Bhavik G. Shroff

[Former Member]

Following SAP note may help you

Note 793113 - FAQ: Oracle I/O configuration