Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
Administering Oracle OLAP, 3 of 9
Several packages described in this guide require that utl_file_dir
be set. This parameter enables the RDBMS to write to a file.
Table 6-1 identifies the parameters that affect the performance of Oracle OLAP. Alter your server parameter file or init.ora
file to these values, then restart your database instance.
See Also:
Oracle9i SQL Reference for information about these parameters. |
Take the following steps to set system parameters:
init
sid
.ora
parameters file in a text editor.
The parameters file is located in $ORACLE_HOME/admin/
sid
/pfile
, where sid is the system identifier as defined in $ORACLE_HOME/network/admin/tnsnames.ora
.
For example, you might enter a command like this so that Oracle can write files to the OraHome1/olap
directory:
UTL_FILE_DIR=/users/oracle/OraHome1/olap
STARTUP
command.
sqlplus '/ as sysdba' shutdown immediate startup pfile=/users/oracle/OraHome1/admin/rel9dw/pfile/initrel9dw.ora
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|