Skip to Content
author's profile photo Former Member
Former Member

SAP Server getting slow when we are running reports like mc.1 fbl3n etc.

Hello,

The time we are running transactions like mc.1 fbl3n, on sm04 the Megabyte column memory showing 578,233 like. that time other users are getting very slow while working.

What is the problem how I can rectify this problem.

please help me

regards

lal

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jan 16, 2008 at 01:43 PM

    Check ST03n for response time in the different areas. Also check ST02 for swaps in memory maybe you'll have to review you memory params.

    Regards

    Juan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2008 at 01:44 PM

    In the DB13, make sure you have schedule the oracle optimizer stats. If not schedule to Run atleast once a week

    login as orasid

    brconnect -c -u / -f stats -t all

    The SAP runs slow if the oracle stats are very old

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2008 at 02:54 PM

    That is a large amount of memory for a standard transaction. You might want to check ST10 to see if the related tables are buffered (transaction tables should not be buffered). Also, check the technical settings for the tables in SE11 and make sure the size settings match the number or records.

    Finally, check with your developers to see if they have made any changes to the index or append tables.

    Hope that helps.

    J. Haynes

    Denver, CO

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.