Enabling and Disabling Workload Tagging Using the Siebel Server Manager

Use the Siebel Server Manager (srvrmgr program) to set the OCI SQL Tagging event type for the applicable Siebel Application Object Manager server component by way of the command-line interface. For more information about Siebel Server Manager, see Siebel System Administration Guide.

To enable and disable workload tagging using the Siebel Server Manager

1. Make sure that the Siebel Application Object Manager server component for your Siebel application is running.

2. Start the srvrmgr program.

   For information about starting the srvrmgr program, see Siebel System Administration Guide.

3. To enable workload tagging, run the following command:

   • change evtloglvl OCISqlTag = loglevel for comp appobjmgr_lang

     where:

   • loglevel determines the types of SQL statements that are tagged (see About Enabling and Disabling Workload Tagging).

   • appobjmgr is the Siebel Application Object Manager server component for your application, and lang is the three-letter identifier for the language specific to your environment.

     For example, the following command enables workload tagging only for SELECT statements for Siebel Call Center for U.S. English:

     change evtloglvl OCISqlTag = 2 for comp sccobjmgr_enu

4. To disable workload tagging, run the following command:

   change evtloglvl OCISqlTag = 0 for comp appobjmgr_lang

   In this command, appobjmgr is the Siebel Application Object Manager server component for your application, and lang is the three-letter identifier for the language specific to your environment.

After workload tagging is enabled, database administrators can then use Oracle Enterprise Manager to diagnose and troubleshoot problematic generated SQL. For information about how to use Oracle Enterprise Manager for workload tagging, see Using Workload Tagging to Troubleshoot Poor Performing SQL at the Database Level.