Improve Performance when Downloading Large Reports
Downloading large reports may require you to increase the timeout settings.
-
Open
<ORACLE HOME>/user_projects/domains/bi/config/fmwconfig/biconfig/bridgeconfig.properties
-
Search for the following parameter:
oracle.bi.presentation.sawconnect.ConnectionPool.SocketReadTimeoutSec
. If it’s not present in the file, add it. -
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
-
Log into the BIG-IP Configuration Utility.
-
From the main tab of the navigation pane, expand Local Traffic and click Profiles, then Protocol, then TCP.
-
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.
Use Oracle HTTP Server for Load Balancing
-
Open
ORACLE_INSTANCE/config/OHS/component_name/mod_wl_ohs.conf
-
Search for the
<IfModule weblogic_module>
section of the file, and add a parameter calledWLIOTimeoutSecs
within that section. -
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.