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.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.Regardless of where these parameters are set, you should check the Oracle Technology Network for updated recommendations.
See Also:
|
|
![]() Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|