BW Performance tuning

[Former Member]

Hi Friends,

We are facing some performance down in our BW production server.

Database is Oracle 10g and OS is HP-UX 11 v2 and 960 GB database size.

What are the things can tuned in database ?

Thanks & Regards

Ganesh Datt Tiwari

[Former Member · Accepted solution]

Hi!

- Try to generate new statistics for tables in the database (not those owned by SYS or SYSTEM) I normally use compute (100%) for smal tables, 50% for medium, and 15-20% for big tables.

- Take those 5-10 most I/O expensive queries in the database and tune them.

- Check if shared_pool_size and db_cache_size are sized correct. If your SGA are bigger than 8-10GB, use huge pages.

Regards

Audun

DBA

[Former Member]

very helpfull

[Former Member]

My suggestion is - Check your EWA for the details from where the load is getting generated and what is hampering the system performance, what are the processes (Activities) utilizing much resources.

If you don't have the EWA option, Just log a call with SAP and let them involve in this issue.

OR

Update this message with more details (HW size, ST06 overview, ST04 overview, no of users etc)

Regards,

Nick Loy

[Former Member]

Have you installed a current Oracle patch set and checked that the parameters are set accordingly (SAP note 830576)?

You might also check st06 and analyse if there is any disk hot spot that results in poor performance.

Kind regards,