Siebel Installation Guide for UNIX > Configuring the RDBMS >

Configuring an Oracle Database for Siebel Applications

This topic contains guidelines for obtaining optimum performance from an Oracle database. These guidelines will be useful to a broad segment of customers. Choose values for the parameters described in this guide that reflect conditions in your particular environment. For additional information, refer to Oracle Database technical documentation.

For additional relevant information, see Overview of Database Configuration.

NOTE:  When Database Configuration Utilities scripts are executed in an Oracle database, as described in Configuring the Siebel Database sequences are generated with the CACHE option. Do not drop these sequences and regenerate them with the NOCACHE option, or performance may be adversely affected and database contention may occur.

Collect statistics for the tables, indexes, and histograms for the columns where the data shape is skewed. Recollect these statistics whenever a large amount of data have been updated, deleted, or inserted. For performance reasons, do not collect statistics for empty tables; for more information, see 478242.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Alert 1162. For details on how to collect statistics, see Oracle Database administration manuals.

Guidelines for Configuring an Oracle Database

Various kinds of guidelines are presented for configuring an Oracle database:

• Guidelines for Selecting a Language for Oracle Database
• Guidelines for Configuring Settings in the init.ora File
• Guidelines for Sizing Redo Logs for an Oracle Database
• Guidelines for Creating Oracle Table Spaces
• Guidelines for Sizing the Oracle Database
• Guidelines for Creating Temporary Oracle Table Spaces
• Guidelines for Defining Oracle Rollback Segments
• Guidelines for Overriding Oracle Default Table Spaces for Database Objects
• Guidelines for Creating Oracle Database Objects
• Guidelines for Ongoing Oracle Database Administration
• Guidelines for Using Real Application Clusters for an Oracle Database