My Oracle Support Banner

Improving the performance of Siebel BI Publisher Report Generation (Doc ID 1392449.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Siebel CRM - Version 8.1.1.1 [21211] and later
Siebel Reports - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

Purpose

This document aims to provide a number of recommendations which can be used to improve the performance of Siebel BI Publisher Report generation.

A number of suggestions are provided and they should be tested in a non-Production environment prior to release.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Determining Performance Issue Faced With Running Siebel BI Publisher Reports
 1) Executing a pre-defined SQL to check if there is a suspected performance issue
 2) Explanation of the Pre-Defined SQL
 Improving the performance of Siebel BI Publisher Report generation
 1) Increasing the amount of heap memory available to the Java Virtual Machine (JVM)
 2) Changing the Server Request Processor DB Polling Interval
 3) Minimize the size of Integration Objects/Components
 4) Ensure that a minimal number of Business Component fields are flagged as Force Active
 5) Ensure that the XMLPReportServer pre-loads the SRF
 6) Reducing the overhead during initial webservice loading
 7) Minimize logging levels on all report generation components
 8) Eliminate any un-necessary scripting during report generation
 9) Generating Large Reports (over 10,000 records)
References

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