|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
Administering Oracle OLAP, 4 of 9
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:
init.orafile, 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.
Regardless of where these parameters are set, you should check the Oracle Technology Network for updated recommendations.