Skip to Content
avatar image
Former Member

Performance Issue

Dears,

I am getting one high response time in my BW server,installed on AIX and Oracle database.

Response time/Dialog step is 7 sec and Avg database time/Dialog step is 5 sec.

There no buffer swaps and work processes are also available.

In ST06 It is showing SAPOSCOL not running?(Shared Memory not available)

In ST04->detailed Analysis->Summary report

I also checked:

Type Client Event Event time (ms) (%)

USER User TOTAL 2.996.443.840 100,00

USER User SQL*Net message from client 2.877.989.120 96,05

Please suggest what should I do to reach root cause of problem.

Shivam

Edited by: Shivam Mittal on Apr 24, 2009 2:26 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 24, 2009 at 10:45 AM

    Hello Shivam,

    the wait event "SQL*Net message from client" is an idle event.. it has mostly no impact on the performance.

    You can check sapnote #619188 for more information.

    Please open a SAP call for this, because of if you don't know how to identify a problem it will be really hard to solve it.

    As you don't tell us your oracle version, etc. it is impossible to help you. Please open a SAP call .. so they can take a look on your system.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2009 at 05:42 AM

    HI,

    You can try to clear shared memory (cmd promt) through OS level..

    Regards,

    Mani

    Add comment
    10|10000 characters needed characters exceeded