2 Improving The Performance of ADF Applications That Contain Oracle BI EE Objects

This chapter describes tuning procedures, such as adding and setting timeouts and using static resources, that you can perform to increase the performance of Oracle ADF applications that contain Oracle BI EE objects.

This chapter includes the following sections:

2.1 Setting an Oracle BI Server Timeout

You can improve system performance by passing properties to Oracle WebLogic Server that specify how long a SOAP request waits for a response from the Oracle BI Server before timing out.

2.1.1 How to Set the Oracle BI Server Timeout

Pass the following properties to Oracle WebLogic Server to tune how long a SOAP request waits for a response from Oracle BI Server before timing out. Note that the initial recommended setting is approximately 60 seconds. The value that you specify should always be less than what is configured for stuck thread detection in WebLogic Server.

For more information about configuring stuck thread detection, see "Tuning the Stuck Thread Detection Behavior" in Oracle Fusion Middleware Performance and Tuning for Oracle WebLogic Server.

For more information, see "Examples of Timeout Settings".

  • -Dsun.net.client.defaultReadTimeout=timeout_in_milliseconds

  • -Dsun.net.client.defaultConnectTimeout=timeout_in_milliseconds

2.1.2 Examples of Timeout Settings

The following examples show how to set the timeout value to 60 seconds.

For Windows:

set CONFIG_JVM_ARGS=-Dsun.net.client.defaultReadTimeout=60000 -Dsun.net.client.defaultConnectTimeout=6000

For Linux:

setenv CONFIG_JVM_ARGS -Dsun.net.client.defaultReadTimeout=60000 -Dsun.net.client.defaultConnectTimeout=60

2.2 Adding a Session Timeout

The Oracle BI ADF integration code supports automatically closing sessions when the ADF HTTP session is closed or times out.

2.2.1 How to Add a Session Timeout

Use the following procedure to modify the application's weblogic.xml so that the application automatically closes.

  1. In JDeveloper, go to the Application Navigator, open the Projects tab, navigate to the project's WEB-INF subdirectory, and open the weblogic.xml document.

  2. Add the following to the document:


2.3 Using Static Resources

You can configure an Oracle BI Presentation Services connection to use static resources that reside either on the Oracle BI Server or another server. The practise of specifying static resources, such as .javascript and .css, can significantly increases the performance of ADF applications that contain Oracle BI EE objects.

2.3.1 How to Set Static Resources Preferences

Use the following procedure to specify static resources preferences for a saved Oracle BI Presentation Services connection.

For information about setting up static resources in Oracle BI EE, see "Improving Oracle BI Web Client Performance" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

For information about creating a new connection and specifying static resources, see "Creating an Oracle BI EE Presentation Services Connection".

  1. In JDeveloper, go to either the Application Resources tab within the Application Navigator or to the Resource Palette and select the Oracle BI Presentation Services connection to modify.

  2. Right-mouse click the selected data connection and select Properties. The Edit BI Presentation Services Connection wizard displays.

  3. In the BI Presentation Services page, specify the static resources settings. Note the following fields:

    • Static Resources Mode– Specify from where to retrieve static resources.

      Select Auto to direct all requests to Oracle BI Presentation Services rather than to the Oracle BI proxy. Selecting Auto results in a significant increase in performance. Note that Auto mode provides the best performance if Oracle WebLogic Server resides behind Oracle HTTP Server or Apache HTTP Server and you are bypassing Oracle WebLogic Server for serving static files.

      Select Manual to direct requests to another location. If you select Manual, you must specify a URL in the Static Resources Location field.

    • Static Resources Location– (Optional) If you selected Manual in the Static Resources Mode field, then enter the location of the deployed static resources if they are not located within the Oracle BI installation. The URL format must be http://host:port/analytics. For example, http://bips:9704/analytics. Examples of static resources are .css and .javascript. Or, leave this field blank if Oracle BI resides behind a firewall but the ports to the ADF instance are not behind a firewall.

  4. Click Finish to save your changes.

2.3.2 Testing The Static Resources Location

Use the following procedure to test that your static resources location settings (URL) are valid.

  1. Create an application that uses the Oracle BI Presentation Services connection in which you specified static resources settings.

  2. From the data connection, browse for an analysis and drag and drop it onto a .jspx page.

  3. Save the application.

  4. Deploy and run the application.

  5. Using a tool such as Firebug, validate that requests for .js and .png files are loaded directly from the static resource URL that you specified in the connection. Note that if you receive 404 (or Not Found) error messages that you have specified an invalid URL in your static resources settings.