In day to day life Siebel application developer has to deal with scenarios where few functionality or some configuration is making Siebel application latent. Developer has to extract the SQL queries to analyze the problematic functionality. We are sharing structured steps to analyze and extract the SQL queries which are leading to latency in Siebel application

Siebel Application Response Management (SARM) is a framework for identifying performance problems in the Siebel enterprise application. SARM allows administrators to collect critical performance and timing data,

In last article "How to capture the eCommunications logs for specific users in Siebel" we have learned How to set user list and log levels.  This article will help us in finding logs for any specific user.

Steps to set high level logs of Object manager for specific users to troubleshoot siebel performance issue.

We can also load Siebel Data & LOV using COM objects. It works like a charm. The obvious advantages are

1. LOVs can be directly exported out of Siebel into csv and copied into an excel. This excel houses a macro with COM object.