Initialization Parameters for the OLAP API

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

If a database instance is being used only to support Java applications that use the OLAP API, 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 an OLAP API session. This method fully isolates these configuration settings solely for the OLAP API. (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 OLAP API.

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

See Also: Chapter 8, "OLAP_API_SESSION_INIT" for information about the read and write APIs Oracle9i SQL Reference for descriptions of initialization parameters that can be set by the ALTER SESSION command