Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring Oracle for Siebel Applications >

Guidelines for Creating Oracle Table Spaces

Initial (minimum) table space allocation recommendation is as follows:

  • Data—5 GB
  • Index—5 GB
  • Rollback segment—1 GB

This allocation is enough for a fresh installation of Oracle (Unicode-enabled or non-Unicode-enabled).

The following additional guidelines should help you in creating table spaces:

  • To improve performance on your production system, create at least two table spaces for Siebel implementation—one for indexes and one for data.
  • Distribute objects that you anticipate to be large or points of contention by creating additional separate table spaces (preferably on separate disk devices).
  • Be sure that you, or whoever is responsible for setting up permissions, grants the Siebel tableowner account the privilege and sufficient quota to create tables and indexes in these table spaces.

    Besides the tableowner, the database user ID used for Siebel Marketing also requires additional rights at the database level within the OLTP schema. You must grant drop table, drop index, create table, and create index rights to this user. For more details, see the Siebel Marketing Installation and Administration Guide.

  • Set storage parameters for your data and index table spaces. The Siebel installation procedure does not set storage parameters for the objects it creates. The storage configuration for each object follows the default storage parameters of its table space.
  • In a development or test environment, multiple Siebel Business Applications installations can coexist on one Oracle instance. Each Siebel installation should be installed under a separate tableowner, so that each schema owner will be unique. For example, more than one test environment can share one Oracle instance.
Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools