Wednesday Oct 26, 2011

OBIEE 11.1.1 - Tuning basic “init.ora” Oracle Database Parameters

The following table provides basic important “init.ora” parameters to tune for Oracle® Business Intelligence instance. Consider following these basic recommendations to set the database parameters. Ultimately, however, the DBA should monitor on periodic basis the database health and tune parameters.


The following table provides information on some important performance-related database initialization parameters to tune for Oracle® 11g Database:

Database Parameter for OBIEE db instance


- whatever is needed to support the expected number of BI applications and application servers.



- the default value for this parameter is too small for systems such as WebLogic Server.

- It is important to set the value of OPEN_CURSORS high enough to prevent system from running out of open cursors.

- Note: assuming that a session does not open the number of cursors specified by OPEN_CURSORS, there is no added overhead to setting this value higher than actually needed.