Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse > Siebel Data Warehouse Requirements >

Oracle-Specific Database Requirements

---

The following requirements apply to Oracle RDBMS usage:

Make the appropriate connections using Oracle Net8 Assistant.
Create the user accounts that access the database. They must have "SSE_ROLE" and be set so that the ddl commands can be run (permissions to create tables).
Set the tablespace for the Siebel Data Warehouse. The tablespace should be at least fifty percent of Siebel Transaction Database size. Default Pctincrease should be zero. Default Initial and Next extent size should be 20M.
Create a login user with the above mentioned tablespace as the default tablespace. The database objects will be created using this user login.
Make sure the temporary tablespace has adequate space.
Use these baseline parameters:

Init.ora parameters
==================================
DB_BLOCK_SIZE 16384
DB_BLOCK_BUFFERS large enough depending on available physical memory.
SHARED_POOL_SIZE 36000000
LOG_BUFFER 11468800
DB_FILE_MULTIBLOCK_READ_COUNT 32
DB_FILE_DIRECT_IO_COUNT 64
SORT_MULTIBLOCK_READ_COUNT 4
SORT_AREA_SIZE 10M
SORT_AREA_RETAINED_SIZE 2M
HASH_AREA_SIZE 20M
OPTIMIZER_MODE see NOTE following these parameters
LOG FILE CONFIGURATION for Database
=====================================

NOTE:  For OPTIMIZER_MODE settings, refer to Full Load Optimizer Settings in Oracle for full load and Incremental Load Optimizer Settings in Oracle for incremental refresh.
For a full load, the optimizer should be set to Rule based in the in the init.ora parameters, thus: OPTIMIZER_MODE RULE.
For an incremental load, the optimizer should be switched to Cost based in the in the init.ora parameters, after analyzing all the data warehouse (W_*) tables, thus: OPTIMIZER_MODE ALL_ROWS.

4 log file groups
10 MB files
Siebel eBusiness Applications under Oracle support only binary sorting. If you are running an Oracle client, do one of the following:
Set the NLS_SORT parameter to BINARY.
Choose a NLS_LANG setting that includes binary.

These settings are required for adequate performance from the Dedicated Web Client.

Bookshelf Home | Contents | Index | Search | PDF