Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring Oracle for Siebel Applications >
Guidelines for 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 table spaces to a minimum of 100 KB.
- Monitor object growth and fragmentation carefully and alter the storage parameters as required.