Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing > Process of Installing the Oracle Warehouse Builder Repository >

Tuning the OLAP Database

There are several important database parameters you must tune for Oracle Warehouse Builder and the ETL Module to function properly.

Verify that the values set are appropriate for your operating system and database environment.

This task is a step in Process of Installing the Oracle Warehouse Builder Repository.

To verify the database parameters

1. Open the initSID.ora initialization file found in the $ORACLE_HOME/dbs directory (in the %ORACLE_HOME%\database directory for Windows) for the Oracle Self-Service E-Billing OLAP database. In the file name, SID is your OLAP database SID. Verify that these parameters are set appropriately for your organization. The following values are the minimum requirement:
   • db_cache_size=256m
   • large_pool_size=64m
   • pga_aggregate_target=512m
   • shared_pool_size=500m
   • job_queue_processes=10
   • aq_tm_processes=1
   • o7_dictionary_accessibility=true
2. Restart the OLAP database.

The database is now ready for installation of the Oracle Warehouse Builder repository schema.