Skip to Content
avatar image
Former Member

Poor Performance on SAP

Dear gurui:

When I run every T-code , it took around more than 10 seconds.

Anything that I can deactivate like system log or any adding cache. please advise the menu.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 20, 2012 at 07:10 AM

    Hi,

    If the entire system is slow, then you have to look at hardware resource utilization first.

    Is CPU being utilized more than 90%. Check main memory utilization.

    Check SAP and Oracle parameters are set as per SAP's standard or not.

    There are many notes available in the marketplace.

    Revert with your details of OS, Database and findings etc.

    Br.

    Venky

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I still cannot run e:\@parameter_check_102.sql

      it just prompt notepad ??

      and according to note 88416

      rdisp/ROLL_MAXFS | [BE] * 100

      [BE] = maximum possible number of users (calculated from [PM])

      what is the formula to calculate from PM??? I cannot find in note??

      my PM = 512

      [PM] = value of the profile parameter PHYS_MEMSIZE (standard

      value=[HS])

      Edited by: Manthana99 on Feb 21, 2012 12:47 AM

  • avatar image
    Former Member
    Feb 21, 2012 at 04:34 PM

    can anybody let me know how to implement 830576

    right now note 1171650 can help note#830576

    but I cannot run via se38-RSORADJV message "The length of the current statement is greater

    than the maximum statement length"

    please advise any other way to change parameter in oracle for notes 830576 .

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      is the script auto update system paramater or not.

      No, The script just shows the SAP recommended values for all of Oracle parameters. It will not update anything in pfile or spfile.

      You as an administrator of the system have to do that.

      and how to update system paramater if the script recommend to do.

      This is nicely explained in orafaq

      http://www.orafaq.com/node/5

      Understand what is PFILEs and SPFILEs

      You should use the command alter system for changing the parameter.

      For e.g.

      ALTER SYSTEM SET open_cursors=300 SCOPE=SPFILE;

      Please revert if you need more clarification.

      Br,

      Venky

      Edited by: Venkatesh Pydi on Mar 4, 2012 4:41 AM

  • avatar image
    Former Member
    Feb 20, 2012 at 07:28 AM

    Hi,

    Is this a new system ? Or were any patches / updates applied ?

    If yes, please make sure that you have run SGEN.

    Also make sure that SAP and DB related parameters are set correctly and that standard jobs like DB stats are scheduled and running correctly.

    Also check and analyze performance related issues from ST03N, ST02, ST04, etc.

    Hope this helps.

    Regards,

    Varun

    Add comment
    10|10000 characters needed characters exceeded