For performance analysis on specific views, it’s useful to examine the SQL statements that the applications generate.
In this way, command line parameters can be specified when Siebel Applications is invoked. The /S option causes Siebel applications to spool all generated SQL. The /S parameter should be specified with a filename into which the generated SQL will be written.
An example of the invocation of a Siebel application with this parameter is:
c:\siebel\bin\siebel.exe /C "c:\siebel\bin\siebel.cfg" /S "c:\temp\spool.sql"
In this example, the application is invoked with siebel.cfg as the configuration file and will write all generated SQL into a file called spool.sql located in c:\temp.
