Average Db time increases

[Former Member]

Hi,

We are facing an increase in the average db time in our ECC system (SAP with oracle).

The average db time/dialog step constitutes around 55% to 60% of the average response time/ dialog step.

Can someone please provide me with the tips/hints to reduce the average db time /dialog step?

Please find the specifications of our Prod systems below:

SAP ECC 6.0

ORACLE 10.2.0.4.0 database of size 3.2 TB.

Thanks in advance,

regards,

Arul Sekar

[Former Member]

Hi Arul,

i had a same issue.. you can try with re starting your server also(cleaning resources).

With Regards,

CSK

[ashish_vikas]

Hello Arul,

if DB time is crossing40%, its surely as issue. You can check few things first :

1. Please check if you have DB stats scheduled and is running properly.

2. Check for poor index quality and rebuild them if required. Also check missing index(DB02).

3. Using ST03N, try to figure out if there are few tcodes for which u have high db time ?? are they sap standard or Z tcodes..

4. Using ST04, check for expensive SQLs and tables they are using. Tune them if u have full table scans.

5. Do u have oracle lock waits as well ?

Hope this will help..

thanks

ashish