My Oracle Support Banner

Why Stored Outlines, SQL Profiles Or Execution Plans May Present Bad Execution Plans After Increasing Event Logging? (Doc ID 1163013.1)

Last updated on DECEMBER 02, 2024

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Goal

Siebel workload tagging is a diagnostic tool that tags SQL statements generated and executed by Siebel CRM running on 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 applications running on 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 the following:

• CLIENT_IDENTIFIER: component_name,servername,taskID,userID,FlowID:SarmID
• ACTION: View Name
• MODULE: Business Component Name

With workload tagging :1 bind variable is dynamically added to SQL statements, see the example below:

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.