Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Database Parameters and Requirements for Siebel Data Warehouse >

Oracle-Specific Database Requirements for Siebel Data Warehouse

---

The following requirements apply to Oracle RDBMS usage:

• Make the appropriate connections using Oracle Net8 Assistant (for Oracle 8 databases) or Oracle Net Service (for Oracle 9 databases).
• Create the user accounts that access the database. They must have SSE_ROLE and be set so that the .dll commands can be run (permissions to create tables).
• Set the tablespace for the Siebel Data Warehouse. Recommended values are shown in Table 5.
• Create a login user with the tablespace as the default tablespace. The database objects will be created using this user login.
• Edit the Init.ora file. Use the recommended baseline parameters shown in Table 5.

Table 5.  Recommended Variable Settings for Oracle Databases

Parameter	Recommended Setting	Notes
Always_anti_join	HASH
Cursor_space_for_time	TRUE	Use only if you do not have many concurrent connections.
Db_block_lru_latches	Set to number of CPUs
Db_block_size	32 k
Db_file_direct_io_count	64
Db_file_multiblock_read_count	STMAXIO / DB_BLOCK_SIZE
Db_file_multiblock_read_count	32
Default Pctincrease	0
Hash_area_size	20 MB
Hash_multiblock_io_count	0.5 * ( db_file_multiblock_Read_count)	Make sure that you are not using MTS.
Initial Extent	20 MB
Log_buffer	16 MB
Next Extent	20 MB
Optimizer_index_caching	Unset	Unset this to avoid nested loops index joins (as favored by the optimizer).
Optimizer_index_cost_adjust	100	See the note following these parameters.
Optimizer_max_permutations	2000	May be applicable to other schemas in the database. This means longer parsing times for the access paths, but once these are parsed, they should remain in the shared_pool, provided they do not get aged out. See notes for Cursor_space_for_time.
Optimizer_mode	ALL_ROWS	Cost-based.
Query_rewrite_integrity	USE_STALE
Rollback_segments		Initial, Next, and Optimum extent size of 50 MB.
Shared_pool_size	150 MB
Sort_area_retained_size	10 MB
Sort_area_size	10 MB
Sort_multiblock_read_count	4
Star_transformation_enabled	TRUE
Tablespace	At least 50% of Siebel transactional database size	Make sure the temporary tablespace has adequate space.
Number of log file groups	4
Size of each Log file	10 MB
Sga_max_size	700 MB

Bookshelf Home | Contents | Index | Search | PDF