High I/O bound System

[Former Member]

Hi All,

I am have a R/3 system on  11.02g version of oracle.

SGA of around 40GB. While the data read from the disk is around 58 GB every hour.

System succumbs under so heavy load. Business requires heavy reports. How to tune oracle to get better results?

Regards,

Swadesh

[Reagan]

Hello

Have you thought about checking the latest EWA report of the system ?

First review that report and get the suggestions implemented.

Regarding the report, check whether there are indexes created and and if yes, then check whether the index is used when the query is executed ?

Do an SQL trace to identify the execution plan.

Regards

RB

[Former Member]

Hi Swadesh

Please let us know certain things :

a) When are you observing system performance degrading ? Is it while running any specific report or transaction ?

b) Is it ECC or BW system ? which SAP version

c)  Was there any recent change in the system or is it a new system

What are the response times you are observing in ST03 ,  how is the memory consumption looking in ST02.

From a DB level - please check the below SAP notes .

618868 - FAQ: Oracle performance

793113 - FAQ: Oracle I/O configuration

Let us know for specific observations ..

Thanks

Rishi