Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows > Creating the Oracle Database > Creating the Database >
Creating Tablespaces
An Oracle Database running Siebel 7.5 requires that the DBA allocate a minimum of 3 GB of space. This space can be allocated as follows:
- Data—1 GB
- Index—2 GB
Allocate a minimum of 500 MB for rollback segment. Be aware that these can grow to as much as 1 GB in size.
This allocation suffices for a fresh installation of Oracle 8i (non-Unicode-enabled) or Oracle 9i (Unicode- or non-Unicode-enabled).
The following additional guidelines should help you in creating tablespaces:
- To improve performance on your production system, create at least two tablespaces 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 tablespaces (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 tablespaces.
NOTE: 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 Siebel Marketing Guide.
- Set storage parameters for your data and index tablespaces. The Siebel installation procedure does not set storage parameters for the objects it creates. The storage configuration for each objects will follow the default storage parameters of its tablespace.
NOTE: In development or test environment, multiple Siebel eBusiness Application installations can co-exist on one Oracle instance. Each Siebel installation can be installed under one tableowner; for example, more than one test environment can share one Oracle instance.
To promote suitable initial sizing and successful installation
- Set the initial extent to a very small size (the minimum is one database block), so that empty tables and indexes do not consume large amounts of space. For example, start with either two or four blocks (in other words, 16 KB or 32 KB with an 8 KB block size). This promotes less fragmentation.
NOTE: Even if you have 10,000 objects, this uses only 312 MB, which is far less space required than for some standard office software packages.
- Set the default next extent for your data and index tablespaces to a minimum of 100 KB.
- Monitor object growth and fragmentation carefully.
NOTE: The Siebel software will automatically alter the storage parameters for certain objects as shown in the example below:
alter table S_PROC_INST_LOG
STORAGE (NEXT 10M PCTINCREASE 0) PCTUSED 90 PCTFREE 5
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |