Bookshelf Home | Contents | Index | PDF |
Siebel Performance Tuning Guide > Tuning Customer Configurations > Analyzing Generated SQL for Performance Issues > Troubleshooting Poor Performing SQL at the Database Level Using Workload TaggingThis topic is part of Analyzing Generated SQL for Performance Issues. Siebel workload tagging is a diagnostic tool that tags SQL statements generated and executed by Siebel Business Applications running on an Oracle database. This tool helps database administrators trace and troubleshoot poor performing SQL or excessive workload at the database level. NOTE: Siebel workload tagging is available only for Siebel Business Applications running on an Oracle database. When workload tagging is enabled, specified Siebel Application Object Manager-generated SQL statements (SELECT, INSERT, UPDATE, DELETE) are tagged with workload tagging attributes. The values for these attributes include:
NOTE: The length of the previous attribute values is limited to 64 bytes for CLIENT_IDENTIFIER, 32 bytes for ACTION, and 48 bytes for MODULE. Truncation occurs when the length exceeds these limitations. When poor performing SQL statements are suspected, the database administrator can use this tagging information to trace details about the generated SQL and the user that initiated it. Database administrators can then use Oracle Enterprise Manager to find the component task and log detail for more in-depth analysis of the performance issue. Alternatively, you can use SQL Plus or similar tools to query the Oracle Database V$SESSION view to look up the CLIENT_IDENTIFIER, ACTION, and MODULE attributes by using SQL_ID of the SQL statement. About Enabling and Disabling Workload TaggingBy default, workload tagging is disabled. You choose which SQL statements you want enabled for workload tagging by setting the log level of the OCI SQL Tagging event type for the applicable Siebel Application Object Manager server component as described in Table 11. NOTE: The OCI SQL Tagging event type is available to all object manager-based components for supported languages, such as Call Center Object Manager (ENU), Sales Object Manager (DEU), eService Object Manager (FRA), and so on. You can use either of the following ways to enable and disable workload tagging:
Requirements for Enabling and Disabling Workload TaggingBefore enabling (or disabling) workload tagging, make sure the following requirements are met:
Enabling and Disabling Workload Tagging Using the Siebel ApplicationUse the following procedure to set the log level of the OCI SQL Tagging event type for the applicable Siebel Application Object Manager server component using the Siebel application GUI. To enable and disable workload tagging using the Siebel application
After workload tagging is enabled, database administrators can use Oracle Enterprise Manager to diagnose and troubleshoot the problematic generated SQL. Related TopicsEnabling and Disabling Workload Tagging Using the Siebel Application Enabling and Disabling Workload Tagging Using the Siebel Server Manager Using Workload Tagging to Troubleshoot Poor Performing SQL at the Database Level Enabling and Disabling Workload Tagging Using the Siebel Server ManagerUse 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
After workload tagging is enabled, database administrators can then use Oracle Enterprise Manager to diagnose and troubleshoot problematic generated SQL. For information on how to use Oracle Enterprise Manager for workload tagging, see Using Workload Tagging to Troubleshoot Poor Performing SQL at the Database Level. Using Workload Tagging to Troubleshoot Poor Performing SQL at the Database LevelUse the following procedure to diagnose and troubleshoot poor performing SQL at the database level using Oracle Enterprise Manager. For more information about Oracle Enterprise Manager, see the documentation on Oracle Technology Network. To use workload tagging to troubleshoot poor performing SQL at the database level
|
Siebel Performance Tuning Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |