Set 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:

• Use Fusion Middleware Control to Disallow Semantic Model Updates

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

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

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

Use Fusion Middleware Control to Disallow Semantic Model Updates

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

Setting this parameter affects whether you can update the semantic model when the Model Administration Tool connects. It also affects whether you can perform other semantic model update operations using other utilities, such as biserverxmlcli. Note that the aggregate persistence feature isn't available when semantic model updates are prevented.

Preventing semantic model updates can improve Oracle BI Server performance, because in this mode the Oracle BI Server doesn't need to handle lock control.

If you choose to prevent semantic model updates, then when the Model Administration Tool opens a semantic model, a message informs the user that the semantic model is read-only.

Before you begin this procedure, ensure that you're familiar with the information in Use Fusion Middleware Control.

1. Go to the Business Intelligence Overview page.
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 semantic model file.
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 Map User Interface Labels with Configuration File Elements.

Use 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're familiar with the information in Use Fusion Middleware Control.

1. Go to the Business Intelligence Overview page.
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.
5. Click Apply, then click Activate Changes to process 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 Map User Interface Labels with Configuration File Elements.

Use 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 Configure for Display and to Process Data in Views.

Before you begin this procedure, ensure that you're familiar with the information in Use Fusion Middleware Control.

1. Go to the Business Intelligence Overview page.
2. Display the Performance tab of the Configuration page.
3. Click Lock and Edit to enable changes to be made.
4. Complete 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 Use Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table View 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 Map User Interface Labels with Configuration File Elements.

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

You can override the maximum number of rows that can be processed from the BI Server for rendering a view.

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

Advanced configuration settings are described in Configure for Display and to Process Data in Views.

Before you begin this procedure, ensure that you're familiar with the information in Use Fusion Middleware Control.

1. Go to the Business Intelligence Overview page.
2. On the Configuration page, select the Performance tab.
3. Click Lock and Edit to enable changes to be made.
4. Complete the Maximum Number of Rows Processed when Rendering A Table View field using the description in the help topic for the page. Enter an integer value greater than 50.
5. Click Apply, then click Activate Changes.
6. Return to the Overview page and click Restart.

Note the following when setting this value:

• 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.

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

• The Maximum Number of Rows Processed when Rendering a Table View field sets ResultRowLimit in instanceconfig.xml (see the Performance tab section in Map 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 Configure Cube Settings for Pivot Tables and Graphs).

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