Siebel Performance Tuning Guide > Tuning Customer Configurations > Analyzing Generated SQL for Performance Issues >

Specifying SQL Spooling in Siebel Developer Web Client

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

Alternatively, after making configuration changes in Siebel Tools, you can spool the SQL that is generated by the Siebel application during runtime 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 the Siebel Installation Guide for the operating system you are using.

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\8.2\Client_1\bin\siebel.exe /c D:\Siebel\8.2\Client_1\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:


  • For the purpose of spooling SQL, you can create shortcuts for Siebel Developer Web Client to run customer applications such as Siebel eService. For example, the shortcut would point to the application configuration file eservice.cfg.
  • You can also 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.
  • Siebel Performance Tuning Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.