Siebel System Monitoring and Diagnostics Guide > Monitoring Siebel Server Run-Time Operations >

Enabling and Disabling SQL Tagging

The SQL tagging feature in Siebel Business Applications is a diagnostic tool that allows administrators to trace long-running or slow-performing queries back to the user or action that triggered it. For more information about SQL tagging, see About Using SQL Tagging to Trace Long-Running Queries in Siebel Business Applications.

By default, SQL tagging is disabled. Administrators can enable SQL tagging by setting the OM SQL Tagging (alias is ObjMgrSqlTag) server component event for a Siebel Application Object Manager server component, such as Call Center Object Manager (ENU). The OM SQL Tagging event is available to all object manager-based components, such as AppObjMgr, EAIObjMgr, BusSvcMgr, and so on. You can enable and disable SQL tagging at any time if the Application Object Manager server component is running.

Enabling SQL Tagging

Use the following procedure to enable SQL tagging.

To enable SQL tagging

1. Navigate to the Administration - Server Configuration screen, then the Components view.
2. In the Components list, select the appropriate Siebel Application Object Manager for the application that you want to enable SQL tagging.

   For example, if the application you are using is Siebel Call Center, then select Call Center Object Manager (ENU).

3. Click the Events subview, and then select the OM SQL Tagging event type.
4. Set the log level to a number greater than 1 (one).

   For more information about setting the log levels, see Setting Log Levels for SQL Tagging.

Disabling SQL Tagging

Use the following procedure to disable SQL tagging.

To disable SQL tagging

1. Navigate to the Administration - Server Configuration screen, Components view.
2. In the Components list, select a Siebel Application Object Manager, for example, Call Center Object Manager (ENU).
3. Click the Events subview, and then select the OM SQL Tagging event type.
4. Set the log level to 1 (one).