Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

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:

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

See Also: