Siebel Installation Guide for UNIX > Configuring the RDBMS >

Configuring an Oracle Database for Siebel Business 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 that are described in this guide that reflect the conditions in your particular environment. For more information, see Oracle Database technical documentation.

See also Overview of Database Configuration.

NOTE:  When scripts from the Siebel Database Configuration Utilities installation are executed in an Oracle Database, as described in Installing the Siebel Database on the RDBMS sequences are generated with the CACHE option. Do not drop these sequences and regenerate them with the NOCACHE option, or else performance might be adversely affected and database contention might occur. If you require additional Oracle sequence objects, then you must create them manually, and you must grant SELECT on these objects to sse_role.

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 has been updated, deleted, or inserted. For more information about how to collect statistics, see the Oracle Database administration manuals.

For performance reasons, do not collect statistics for an empty table. For more information, see 478242.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Alert 1162.

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 Tablespaces
• Guidelines for Sizing the Oracle Database
• Guidelines for Creating Temporary Oracle Tablespaces
• Guidelines for Overriding Oracle Default Tablespaces 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