Improve Performance when Downloading Large Reports

Downloading large reports may require you to increase the timeout settings.

If downloading a report takes more than 6 minutes, increase the timeout setting as follows:

1. Open <ORACLE HOME>/user_projects/domains/bi/config/fmwconfig/biconfig/bridgeconfig.properties 

2. Search for the following parameter: oracle.bi.presentation.sawconnect.ConnectionPool.SocketReadTimeoutSec. If it’s not present in the file, add it.

3. The default value for this parameter is 360 seconds (6 minutes). Increase the parameter as needed and save the configuration file.

Use F5 BIG-IP for Load Balancing

If you’re using F5 BIG-IP for load balancing and a large report takes more than 5 minutes to download, increase the timeout setting as follows:

1. Log into the BIG-IP Configuration Utility.

2. From the main tab of the navigation pane, expand Local Traffic and click Profiles, then Protocol, then TCP.

3. In your TCP profile, search for the Idle Timeout field. The default value for this parameter is 300 seconds (5 minutes). Increase the parameter as needed.

For information on the timeout setting, refer to the ASKF5 Knowledge Center article K7559: Overview of the TCP profile (9.x-10.x)

Use Oracle HTTP Server for Load Balancing

If you’re using Oracle HTTP Server for load balancing and a large report takes more than 5 minutes to download, increase the timeout setting as follows:

1. Open ORACLE_INSTANCE/config/OHS/component_name/mod_wl_ohs.conf

2. Search for the <IfModule weblogic_module> section of the file, and add a parameter called WLIOTimeoutSecs within that section.

3. The default value for this parameter is 300 seconds (5 minutes). Increase the parameter as needed and save the configuration file. Restart Oracle HTTP Server.

See Parameters for Web Server Plug-Ins in Using Oracle WebLogic Server Proxy Plug-Ins.