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 tune the database parameters

  1. Open the initSID.ora initialization file for the Oracle Self-Service E-Billing database, located in the following directory:
    • UNIX. $ORACLE_HOME/dbs
    • Windows. %ORACLE_HOME%\database

      In the file name, SID is your EBILL database SID.

  2. 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
  3. Restart the EBILL database.

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

Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.