Skip to Content
avatar image
Former Member

BW Performance tuning

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 14, 2011 at 07:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 11, 2011 at 06:46 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 11, 2011 at 08:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2011 at 10:15 AM

    very helpfull

    Add comment
    10|10000 characters needed characters exceeded