Configuring an Oracle Database for Siebel CRM

This topic includes 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.

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 Database 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 the Siebel Performance Guide.

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 Database Tablespaces

• Guidelines for Sizing the Oracle Database

• Guidelines for Creating Temporary Oracle Database Tablespaces

• Guidelines for Overriding Oracle Database 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

• Guidelines for Optimizing Oracle Parallel Queries for Siebel Web Tools

• Guidelines for Installing the Siebel Database in a Pluggable Database

Related Topics

Installing the Siebel Database on the RDBMS

Planning RDBMS Installation and Configuration

Overview of Database Configuration

Specifying the Locale for Siebel CRM

Verifying Installation for the Siebel Database

Related Books

Oracle Database SQL Language Reference

Oracle Database Administrator’s Guide