Initialization Parameters for the BI Beans - OLAP

The BI Beans will perform best if the configuration parameters for the database are optimized for this type of use. During installation of the Oracle Database, an OLAP configuration table is created and populated with ALTER SESSION commands that have been tested to optimize the performance of the BI Beans. Each time the BI Beans opens a session, it executes these ALTER SESSION commands.

If a database instance is being used only to support Java applications that use the BI Beans, then you can modify your server parameter file or init.ora file to include these settings. Alternatively, you might want to include some of the settings in the server parameter file and leave others in the table, depending upon how your database instance is going to be used. These are your choices:

  • Keep all of the parameters in the configuration table, so that they are set as part of the initialization of a BI Beans session. This method fully isolates these configuration settings solely for the BI Beans. (Default)
  • Add some of the configuration parameters to the server parameter file or init.ora file, and delete those rows from the configuration table. This is useful if your database is being used by other applications that require the same settings.
  • Add all of the configuration parameters to the server parameter file or init.ora file, and delete all rows from the configuration table. This is the most convenient if your database instance is being used only by the BI Beans.

Regardless of where these parameters are set, you should check the Oracle Technology Network for updated recommendations.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

OLAP Topics