Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an Oracle Database for Siebel Business Applications >

Guidelines for Sizing the Oracle Database

Monitor object growth and fragmentation carefully and alter the database storage parameters as required. Also use the following guidelines for initial sizing of your Oracle Database. (If you use EXTENT MANAGEMENT LOCAL AUTOALLOCATE for CREATE DATABASE, then these guidelines do not apply.)

  • 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 as many 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.

This topic is part of Configuring an Oracle Database for Siebel Business Applications.

Siebel Installation Guide for UNIX Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.