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.
Edited by: Shivam Mittal on Apr 24, 2009 2:26 PM