Specifying SQL Spooling in Siebel Developer Web Client

This topic is part of Analyzing Generated SQL for Performance Issues.

Optionally, after making configuration changes in Siebel Tools, you can spool the SQL that is generated by the Siebel application during runtime. You do this to troubleshoot configuration-related performance issues.

To spool the generated SQL into a trace file, start the Siebel application in the Siebel Developer Web Client (connecting to the Siebel database) using the command-line option /s sql_trace_file. For more information about installing and running the Siebel Developer Web Client, see Siebel Installation Guide.

The SQL trace file contains all of the unique SQL statements generated during the current session, and identifies the amount of time spent processing each one. The trace file can be opened in a text editor for examination after the session has ended. The SQL trace file, which is simply a text file holding the spooled SQL from the session, is overwritten during every new session.

You can specify the /s sql_trace_file option by modifying properties for the Start menu item or desktop shortcut from which the Siebel application is invoked. The following example shows a command line for spooling generated SQL from Siebel Call Center using the Siebel Developer Web Client:

"D:\Siebel\Client\bin\siebel.exe /c D:\Siebel\Client\bin\enu\uagent.cfg /s siebel_
sql.txt"

If you do not specify a path, then the SQL trace file is created in the Siebel client root bin directory, such as D:\Siebel\Client\bin.

You can programmatically start and stop SQL spooling though the Siebel Object Interfaces by using the TraceOn and TraceOff methods on the Application object. For more information about these methods, see Siebel Object Interfaces Reference.