Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Creating Oracle Database Objects >

Sizing the Oracle Database

Use these guidelines to do initial sizing of your Oracle database:

• 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 allocation promotes less fragmentation.

  Even if you have 10,000 objects, this number of objects 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 and alter the storage parameters as required.