Database Performance

[mukundk_sap]

Hello All

WIN2k3+ORA10g

Is there any connection between PRD Client (keeping in non custmizing mode) and Database Performace.

b'coz when i am open the PRD Client ( Automatic Recording of Changes ) the DB quality is above 95%.

But if i closed the client (No changes allow) the DB Quality is going down ( below 75% and going on... )

Thanks in Advance..

[Former Member · Accepted solution]

Mukund,

I dont think thr is any connection between PRD Client (keeping in non custmizing mode) and Database Performace.

Note 618868 - FAQ: Oracle performance

http://help.sap.com/erp2005_ehp_04/helpdata/EN/c4/3a71fc505211d189550000e829fbbd/content.htm

http://help.sap.com/erp2005_ehp_04/helpdata/EN/c4/3a6fda505211d189550000e829fbbd/frameset.htm

Hope this helps.

Thanks

Sushil

[mukundk_sap · Accepted solution]

Sushil / Presu

Appreciate your guideline

Thanks for that.

Update statistics is regularly doing in background job.

But from morning i am monitoring the db quality. Itu2019s up when I open the client and it goes down when i close the client. I had done this twice and monitor for 2 hrs after changing client option.

[Former Member · Accepted solution]

Check Ur Background Jobs. as well as moitor system by t-code SM50

and regulerly check SAP dump

Thanks

presu

[Former Member]

No it is not happen with cliient options. do one thing before doing any activity run Update database statistics by brtools.

Thanks

Presu