Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Configuring the RDBMS >

Configuring Oracle for Siebel Applications

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

For additional relevant information, see Overview of Database Configuration.

NOTE:  When Siebel Database Server scripts are executed in an Oracle database, as described in Installing the Siebel Database Server and 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.

You should 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 Alert 1162 on Siebel SupportWeb. For details on how to collect statistics, see Oracle administration manuals.

After you have completed configuring your DB2 UDB database, you can perform all Siebel installation tasks, including those described in Installing the Siebel Database Server and Configuring the Siebel Database.