Siebel Performance Tuning Guide


What's New in This Release


Back to top


Siebel Architecture and Infrastructure

About Performance and Scalability

About Siebel Architecture and Infrastructure

About Siebel User Request Flow

Performance Tuning Terminology


Back to top


Tuning Siebel Application Object Manager

About the Siebel Application Object Manager

Siebel Application Object Manager Infrastructure

Performance Factors for Siebel Application Object Manager Deployments

Topology Considerations for Siebel Application Object Manager Deployments

Guidelines for Siebel Application Object Manager Tuning

Tuning Siebel Application Object Manager Components for CPU and Memory Utilization

Tuning Parameters for Siebel Application Object Manager Caches

Additional Parameters Affecting Siebel Application Object Manager Performance

Memory Consumers in Siebel Application Object Manager

Configuring Database Connection Pooling for Siebel Application Object Managers

About Database Connections for Siebel Application Object Manager

Database Connection Pooling Usage Guidelines

Configuring Pooling for Default Database Connections

Configuring Pooling for Specialized Database Connections

Using Thread Pooling for Siebel Application Object Manager


Back to top


Tuning the Siebel Server Infrastructure

Configuring SISNAPI Connection Pooling for Siebel Application Object Manager

Tuning Server Request Broker (SRBroker)


Back to top


Tuning Siebel Web Client

About Siebel Clients

Performance Factors for Siebel Web Clients

Guidelines for Siebel Web Client Tuning

Providing Sufficient Web Server and Network Capacity

Testing Performance for Web Clients

Providing Sufficient Client Hardware Resources

Tuning System Components

Following Configuration Guidelines

Managing the Browser Cache

Specifying Static File Caching

Improving Performance Using View Layout Caching

Configuring the Data Block Size of HTTP Requests for the Siebel Dedicated Client

Managing Performance Related to the Message Bar

Configuring the Busy Cursor for Standard Interactivity Applications


Back to top


Tuning Siebel Communications Server

About Siebel Communications Server

Session Communications Infrastructure

Performance Factors for Session Communications

Topology Considerations for Session Communications

Guidelines for Session Communications Tuning

Tuning the Siebel Application Object Manager Component

Tuning the CommSessionMgr Component

Conserving Siebel Application Object Manager Server Resources Through Caching

Improving Performance for Communications Configurations

Configuring Logging for Session Communications

Improving Availability for Session Connections

Improving Screen Pop Performance

Reviewing Performance Impact of Activity Creation

Siebel Email Response Infrastructure

Performance Factors for Siebel Email Response

Topology Considerations for Siebel Email Response

Guidelines for Siebel Email Response Tuning


Back to top


Tuning Siebel Workflow

About Siebel Workflow

Monitoring Workflow Policies

Using the Policy Frequency Analysis View

Using Workflow Agent Trace Files

Monitoring Workflow Policies Tables

Tuning Workflow Policies for Performance

Creating Workflow Policy Groups to Manage Siebel Server Load

Multiple Workflow Monitor Agents and Workflow Action Agents

Running Workflow Agents on Multiple Siebel Servers

Setting Optimal Sleep Interval for Workflow Policy Groups

Setting Optimal Action Interval for Workflow Monitor Agent and Workflow Action Agent

Tuning Workflow Processes

Minimizing Usage of Parameter Search Specification

Monitoring Conditions Based on Parent and Child Business Components

Configuring Siebel Business Applications for Workflow Performance

Monitoring Memory Overhead for Workflow Processes

Tuning Workflow Process Manager for Performance

Caching Business Services

Caching Sessions


Back to top


Tuning Siebel Configurator

Siebel Configurator Infrastructure

Performance Factors for Siebel Configurator

Considerations for Defining Topology for Siebel Configurator

Running Siebel Configurator in the Siebel Application Object Manager Component

Running Siebel Configurator on Dedicated Servers

Guidelines for Siebel Configurator Tuning

Tuning Siebel Configurator

Specifying the Siebel Configurator File System Location

Defining Customizable Product Models and Classes

About Siebel Configurator Caching

Default Caching Behavior for Siebel Configurator

Cache Management for Siebel Configurator

Parameters for Configuring Siebel Configurator Caching

Determining Rough Sizing for Caching Parameters

Administering the Siebel Configurator Cache

Refreshing the Entire Siebel Configurator Cache

Refreshing the Siebel Configurator Cache with Product Changes

Updating the Siebel Configurator Cache with Product Class Changes

Refreshing the Siebel Configurator Cache with Product Class Changes

Updating the Siebel Configurator Cache with Attribute Definition Changes

Refreshing the Siebel Configurator Cache with Attribute Definition Changes


Back to top


Tuning Siebel EAI

About Siebel Enterprise Application Integration

Guidelines for Siebel EAI Tuning

Improving IBM WebSphere MQ Transport Performance

Improving HTTP Inbound Transport Performance

EAI Siebel Adapter Performance

Virtual Business Component Performance

Improving Workflow Process Manager Performance

Other Guidelines for Siebel EAI


Back to top


Tuning Siebel EIM

About Siebel EIM

Siebel EIM Architecture Planning Requirements

Database Sizing Guidelines

Database Layout Guidelines (Logical and Physical)

Siebel EIM Usage Planning

Defining the Siebel EIM Team

Mapping Data into Siebel Business Applications

Testing Siebel EIM Processes

General Guidelines for Optimizing Siebel EIM

Recommended Sequence for Implementing Siebel EIM Processes

Optimizing the .IFB File for Siebel EIM

Checking .IFB File Optimization for Siebel EIM

Separating Siebel EIM Processes by Operation

Troubleshooting Siebel EIM Performance

Optimizing SQL for Siebel EIM

Using the USE INDEX HINTS and USE ESSENTIAL INDEX HINTS Parameters

Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Example

Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Criteria for Passing Indexes to the Database

Using the SQLPROFILE Parameter

Additional Indexes on Siebel EIM Tables

Creating Proper Statistics on Siebel EIM Tables

Dropping Indexes in Initial Runs of Siebel EIM

Controlling the Size of Batches for Siebel EIM

Controlling the Number of Records in Siebel EIM Tables

Using the USING SYNONYMS Parameter with Siebel EIM

Using the NUM_IFTABLE_LOAD_CUTOFF Extended Parameter with Siebel EIM

Disabling the Docking: Transaction Logging Parameter for Siebel EIM

Disabling Database Triggers for Siebel EIM

Running Siebel EIM Tasks in Parallel

Database Guidelines for Optimizing Siebel EIM

Microsoft SQL Server and Siebel EIM

Oracle Database and Siebel EIM

IBM DB2 for z/OS and Siebel EIM

IBM DB2 for z/OS and Siebel EIM

IBM DB2 for z/OS Loading Process for Siebel EIM

General Recommendations for the IBM DB2 for z/OS Loading Process

Data Management Guidelines for Optimizing Siebel EIM

Run Parameter Guidelines for Optimizing Siebel EIM

Monitoring the Siebel Server During a Siebel EIM Task


Back to top


Tuning Siebel Remote

About Siebel Remote

Tuning Siebel Remote Server Components

Increasing Throughput for the Database Extract and Parallel Database Extract Components

Tuning the Transaction Router Component

Tuning the Mobile Web Client in a Siebel Remote Deployment

Optimizing Application Configuration File Parameters

Guidelines for Optimizing Data Synchronization Between Siebel Mobile Web Client and Siebel Remote Client

Choosing an Appropriate Routing Model


Back to top


Tuning Customer Configurations

General Performance Guidelines for Customer Configurations

Analyzing Generated SQL for Performance Issues

About Specifying SQL Logging and SQL Tagging for Siebel Application Object Manager Components

Troubleshooting Poor Performing SQL at the Database Level Using Workload Tagging

Specifying SQL Spooling in Siebel Developer Web Client

Troubleshooting Performance Using SQL Trace Files

Troubleshooting Performance Using SQL Query Plans

Performance Guidelines for Siebel Scripting

Using Declarative Alternatives to Siebel Scripting

Siebel Scripting Guidelines for Optimal Performance

Performance Guidelines for Data Objects Layer

Multilingual LOVs Query and Cache Performance

Managing Database Indexes in Sorting and Searching

Reusing Standard Columns

Performance Guidelines for Business Objects Layer

Using Cache Data Property to Improve Business Component Performance

Limiting the Number of Active Fields

Guidelines for Using Calculated Fields

Using Properties to Improve Picklist Performance

Using Primary ID Fields to Improve Performance

How the Check No Match Property Impacts Performance

Performance Guidelines for User Interface Objects Layer

Addressing Performance Issues Related to Grid Layout

Maintaining Performance When Using Applet Toggles


Back to top


Tuning the Web Server Computer for All UNIX and Linux Platforms

Tuning Microsoft Windows for Enhanced Siebel Server Performance

Tuning the Siebel Server for All UNIX and Linux Platforms

Tuning the Web Server Computer for All Applicable UNIX and Linux Platforms

Tuning the Siebel Web Server Extension for All UNIX and Linux Platforms

Tuning an Apache Web Server for Applicable UNIX and Linux Platforms

Tuning Siebel Business Applications for AIX

Tuning the IBM HTTP Server for AIX

Tuning the Siebel Server for AIX

Tuning Kernel Settings for AIX

Tuning Siebel Business Applications for HP-UX

Tuning Kernel Settings for HP-UX

Setting Permissions for the HP-UX Scheduler

Tuning Siebel Business Applications for Oracle Solaris

Tuning the Oracle iPlanet Web Server

Tuning Kernel Settings for Oracle Solaris

Tuning Siebel Application Object Manager Instances for Oracle Solaris


Back to top


Monitoring Siebel Application Performance with Siebel ARM

About Siebel Application Response Measurement

About Siebel ARM Parameters and Variables

Enabling and Configuring Siebel ARM

Guidelines for Converting Siebel ARM Files


Back to top


Analyzing Siebel ARM Data

About Siebel ARM Files

Analyzing Siebel ARM Files Using the Siebel ARM Query Tool

About the Siebel ARM Query Tool

General Commands for the Siebel ARM Query Tool

Configuring the Siebel ARM Query Tool

Configuring Input for the Siebel ARM Query Tool

Configuring Output from the Siebel ARM Query Tool

Using Selection Filters with the Siebel ARM Query Tool

Aggregating Siebel ARM Data with the Siebel ARM Query Tool

Generating Histograms with the Siebel ARM Query Tool

Using Macros with the Siebel ARM Query Tool

Analyzing Siebel ARM Files Using the Siebel ARM Analyzer Tool

About the Siebel ARM Analyzer Tool

Running Performance Aggregation Analysis

Running Call Graph Generation

Running User Session Trace

Running Siebel ARM Data CSV Conversion

About Siebel ARM Analyzer Output Files

About Performance Aggregation Analysis and Data

About Call Graph Generation Analysis and Data

About User Session Trace Analysis and Data

About Siebel ARM to CSV Conversion Data

Back to top

Siebel Performance Tuning Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.