Setting Performance Parameters in Fusion Middleware Control

There are several performance options that you can set in Fusion Middleware Control.

This section contains the following topics:

• Using Fusion Middleware Control to Disallow RPD Updates

• Using Fusion Middleware Control to Set the User Session Log-Off Period

• Using Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables

• Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table

Using Fusion Middleware Control to Disallow RPD Updates

You can use Fusion Middleware Control to allow or prevent updates to the default repository file.

Setting this parameter affects whether you can update the repository when the Administration Tool connects in both online and offline mode. It also affects whether you can perform other repository update operations using other utilities, such as biserverxmlcli. Note that the aggregate persistence feature is not available when repository updates are prevented.

Preventing repository updates can improve Oracle BI Server performance, because in this mode, the Oracle BI Server does not need to handle lock control.

If you choose to prevent repository updates, then when the Administration Tool opens a repository in either online or offline mode, a message informs the user that the repository is read-only.

Before you begin this procedure, ensure that you are familiar with the information in Using Fusion Middleware Control.

To use Fusion Middleware Control to prevent repository updates:

1. Go to the Business Intelligence Overview page, as described in Displaying Oracle Business Intelligence Pages in Fusion Middleware Control.
2. Display the Performance tab of the Configuration page.
3. Click Lock and Edit to enable changes to be made.
4. Select Disallow RPD Updates to prevent updates to the repository file.

   Click the Help for this page menu option to access the page-level help.

5. Click Apply, then click Activate Changes.
6. Go to the Processes tab of the Availability Page and click Restart All.

For information about corresponding configuration file elements, see Mapping User Interface Labels with Configuration File Elements.

Using Fusion Middleware Control to Set the User Session Log-Off Period

You can override the time to elapse, in minutes, before a user is automatically logged off.

Before you begin this procedure, ensure that you are familiar with the information in Using Fusion Middleware Control.

To use Fusion Middleware Control to set the client session log-off period:

1. Go to the Business Intelligence Overview page, as described in Displaying Oracle Business Intelligence Pages in Fusion Middleware Control.
2. Display the Performance tab of the Configuration page.
3. Click Lock and Edit to enable changes to be made.
4. Complete the User Session Expiry option using the description in the help topic for the page.

   Click the Help for this page menu option to access the page-level help.

5. Click Apply, then click Activate Changes to execute your changes and release the lock to enable another system administrator to make changes.
6. Return to the Business Intelligence Overview page and click Restart.

For information about corresponding configuration file elements, see Mapping User Interface Labels with Configuration File Elements.

Using Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables

This procedure describes basic configuration options for data in tables and pivot tables.

Advanced configuration settings are described in Configuring for Displaying and Processing Data in Views.

Before you begin this procedure, ensure that you are familiar with the information in Using Fusion Middleware Control.

To use Fusion Middleware Control to set configuration options for views:

1. Go to the Business Intelligence Overview page, as described in Displaying Oracle Business Intelligence Pages in Fusion Middleware Control.
2. Display the Performance tab of the Configuration page.
3. Click Lock and Edit to enable changes to be made.
4. Complete the elements using the descriptions in the help topic for the page.

   Click the Help for this page menu option to access the page-level help for the following options:

   • Maximum Number of Rows to Download option

   • Maximum Number of Rows Per Page to Include option

     Note:

     In general, the 'Maximum Number of Rows to Download' option and the 'Maximum Number of Rows Processed when Rendering a Table View' option discussed in Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table should be set to the same values to avoid getting 'Exceeded configured maximum number of allowed input records' errors.
5. Click Apply, then click Activate Changes.
6. Return to the Business Intelligence Overview page and click Restart.

For information about corresponding configuration file elements, see Mapping User Interface Labels with Configuration File Elements.

Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table

You can override the maximum number of rows that can be fetched and processed from the Oracle BI Server for rendering a table.

Reducing the number of rows in a table can significantly improve performance by reducing the system resources that can be consumed by a given user session.

Advanced configuration settings are described in Configuring for Displaying and Processing Data in Views.

Note the following when setting this value:

• This specification applies to tables, not to pivot tables.

• The default value is 65000. The minimum value is 50. If the user exceeds the maximum value, then the server returns an error message when the table view is rendered. The maximum value is at least 16 bits, which varies by platform. The system is likely to consume all its memory before approaching a number larger than this value.

Before you begin this procedure, ensure that you are familiar with the information in Using Fusion Middleware Control.

To use Fusion Middleware Control to set the maximum number of rows that are processed when rendering a table:

1. Go to the Business Intelligence Overview page, as described in Displaying Oracle Business Intelligence Pages in Fusion Middleware Control.
2. Display the Performance tab of the Configuration page.
3. Click Lock and Edit to enable changes to be made.
4. Complete the Maximum Number of Rows Processed when Rendering A Table View option using the description in the help topic for the page. Enter an integer value greater than 50.

   Click the 'Help for this page' menu option to access the page-level help for the box.

   Note:

   In general, the 'Maximum Number of Rows Processed when Rendering a Table View' option and the 'Maximum Number of Rows to Download' option discussed in Using Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables should be set to the same values to avoid getting 'Exceeded configured maximum number of allowed input records' errors.

   Note:

   The 'Maximum Number of Rows Processed when Rendering a Table View' option sets ResultRowLimit in instanceconfig.xml (see the Performance tab section in Mapping User Interface Labels with Configuration File Elements). Both ResultRowLimit and CubeMaxRecords limit the number of rows returned, and the limit is determined by the setting with the larger value (see Manually Configuring Cube Settings for Pivot Tables and Graphs).
5. Click Apply, then click Activate Changes.
6. Return to the Business Intelligence Overview page and click Restart.

For information about corresponding configuration file elements, see Mapping User Interface Labels with Configuration File Elements.