on 04-24-2009 9:43 AM
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
HI,
You can try to clear shared memory (cmd promt) through OS level..
Regards,
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
enable tracing on the session in question and then run tkprof against the trace file.
http://www.adp-gmbh.ch/ora/tuning/tkprof/index.html
HTH
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.