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

How to Tune the Transactions/ Z - reports /Progr..of High response time

Dear friends,

in <b>ST03</b> work load anlysis menu.... there are some z-reports, transactions, and some programmes are noticed contineously that they are taking the <b>max. response time</b> (and mostly >90%of time is DB Time ).

how to tune the above situation ??

Thank u.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Nov 29, 2007 at 02:24 PM

    you go get SAP course "ADM315: Workload Analysis".

    it is too complicated to explain all the steps in a forum.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 05:49 PM

    Siva,

    You can start with some thing like:

    ST04 -> Detail Analysis -> SQL Request (look at top disk reads and buffer get SQL statements)

    For the top SQL statements identified you'd want to look at the explain plan to determine if the SQL statements is:

    1) inefficient

    2) are your DB stats up to date on the tables (note up to date stats does not always means they are the best)

    3) if there are better indexes available, if not would a more suitable index help?

    4) if there are many slow disk reads, is there an I/O issue?

    etc...

    While you're in ST04 make sure your buffers are sized adequately.

    Also make sure your Oracle parameters are set according to this OSS note.

    Note 830576 - Parameter recommendations for Oracle 10g

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 29, 2007 at 11:46 PM

    I´d execute that program with an enabled trace (using ST05) and blame the developers for using "select * from xy" 😉

    --

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Fidel Vales

      yes but maybe there are too many indices already (which would also be counterproductive). i'd stay with markus and search for selects without proper conditions, nested loops and irresponsibly large joins (over more than 2 tables).

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.