Siebel Installation Guide for Microsoft Windows > 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:

Siebel Installation Guide for Microsoft Windows Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.