Bookshelf Home | Contents | Index | PDF |
Siebel Performance Tuning Guide > Tuning Customer Configurations > Analyzing Generated SQL for Performance Issues > About Specifying SQL Logging and SQL Tagging for Siebel Application Object Manager ComponentsThis topic is part of Analyzing Generated SQL for Performance Issues. SQL logging and SQL tagging are diagnostic tools that log and tag SQL statements generated and executed by Siebel Business Applications. When used in conjunction with SQL logging, SQL tagging can help administrators trace long-running or slow-performing SQL queries back to the user or action that triggered them. You can also use these tools to review generated SQL in a development or test environment after making configuration changes in Siebel Tools.
With SQL tagging, data that can be logged includes the server component name, server name, task ID, user ID, flow ID (with Siebel ARM ID), business object name, business component name, and view name. Which elements are logged depends on the level set for the event. NOTE: SQL tagging requires that you have installed Siebel CRM version 8.1.1.1 or later. For instructions on how to use SQL tagging and logging to log and tag generated SQL statements at the server component level, see Siebel System Monitoring and Diagnostics Guide. |
Siebel Performance Tuning Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |