Siebel SWSE Stats to identify performance issue

Siebel SWSE Stats to identify performance issue

Yesterday came across this Oracle support Article Doc ID 478027.1 while trying to debug performance issue. This article provide details about Stats.swe page that can help you provide valuable information to troubleshoot some hang issues with the application.

To visit the stats page you need to open following URL

http://<webserver>/<application>/_stats.swe?verbose=high

It shows all kind of stats and the most important section is Current Operations Processing. The “Current Operations Processing” section contains a table which shows all current requests that are in progress. The table in this section shows the Operation running in the left column and the Duration in right column. Requests that are highlighted in bold have been running for more than 10 seconds. A request that is highlighted in bold with a large duration value is another indication that this request may be hanging. If the request never completes then it has effectively hung.

Both application and database server hangs can exhibit the above behavior in the stats page. Typically if the stats page cannot be accessed, then this is an indication that the web server itself may have hung.

Below is the screenshot of how the page looks like:

image

This gives one more tool in application teams arsenal. Instead of waiting for Admin they can use this page to quickly identify areas suspected of Performance issues.

Happy Debugging!!

3 Responses to Siebel SWSE Stats to identify performance issue

  1. Hi, Many Thanks for sharing,

    Just one note, the link to the Oracle Article, points to an OBIEE article.

    Can you change to the correct article?

    Regards,
    NF

    • Updated the link, here is the title and Doc ID or article for your reference.

      How To Troubleshoot Hangs on UNIX Systems in Siebel Environments (Doc ID 478027.1)

  2. Hi neel,

    I thought that the article was about swe stats analysis, fortunately i already know that documment and believe it was of great help.

    There is one to Windows system to, and some documments are very usefull in performance and issue analysis i leave here some:

    How to troubleshoot Siebel component crashes on Microsoft Windows (Doc ID 477511.1)
    How To Troubleshoot Siebel Server Component Crashes on UNIX (Doc ID 477520.1)
    How To Troubleshoot Memory Leaks on Microsoft Windows (Doc ID 477521.1)
    How To Troubleshoot Memory Leaks on UNIX (Doc ID 477522.1)
    How To Analyze the FDR Output in Siebel Versions 7.7.x, 7.8.x and 8. (Doc ID 473939.1)

Leave a Reply

Contribute