Skip to Content
avatar image
Former Member

SAP is still slow after ram upgrade.

Hi Experts,

We recently upgraded our memory from 16Gb to 32Gb. Then we adjusted the SGA_MAX_SIZE to 27Gb and left our SGA_TARGET at 0 but our system still gets a little slow sometimes. Can anybody suggest what parameters to check in sap and in oracle. The version of our Oracle is 10g and our SAP is ecc 6.0. Any suggestion would be much appreciated.

Thank You

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 18, 2013 at 04:47 AM

    Hi Rosendo,

    Just Go to ST04 and check Data buffer Quality Buffer % , if it is less than 90 % the database tuning is required. For this increase SGA_MAX_SIZE and also SGA_TARGET parameters but SGA_TARGET < = SGA_MAX_SIZE. I have done this after increasing my RAM and my data Buffer % increases to 98.4 %.

    For clearing concept of SGA_MAX_SIZE and also SGA_TARGET go to below link:

    http://oracledbaschool.blogspot.in/2009/05/sgatarget-vs-sgamaxsize.html

    Regards

    Yogesh Garg

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 18, 2013 at 03:45 AM

    Hi Ariola,

    Could you update the following statistics for your database

    1) Missing statistics

    2) Oracle dictionary statistics

    3) System statistics

    Additionally you may need to check ST02, you identify whether system is swaping or not. Incase it is swapping a lot you may need to adjust those buffer parameters using RZ10.

    Post these updates, observe system performance.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Rosendo,

      If I understood correctly, you are asking whether the buffer paramater value set is too high or not ( to avoid swapping)

      -> Tuning SAP buffers is iterative. Hence you need to keep on updating these values based on system behaviour and requirement. Question here is whether configured values will be supported by SAP system or not. It depends upon available RAM for SAP application. Ideal practise for OLTP systems is 30% of total RAM to Database and 70% of total RAM to SAP applicaiton.

      By mistake you put very large values to have your SAP buffers on higher end and take a restart, SAP system won't come up.

      Regards,

      Deepak Kori