Siebel Performance Tuning Guide > Tuning Siebel EIM > Siebel EIM Architecture Planning Requirements >

Database Layout Guidelines (Logical and Physical)


This topic is part of Siebel EIM Architecture Planning Requirements.

The overall performance of Siebel Business Applications largely depends on the input/output (I/O) performance of the database server. To achieve optimal I/O performance, it is critical that the tables and indexes in the database be arranged across available disk devices in a manner that evenly distributes the I/O load.

The mechanism for distributing database objects varies by RDBMS, depending on the manner in which storage space is allocated. Most databases have the ability to assign a given object to be created on a specific disk. These objects, and guidelines for some of them, are provided in the following list.

A redundant array of independent disks, or RAID, can provide large amounts of I/O throughput and capacity, while appearing to the operating system and RDBMS as a single large disk (or multiple disks, as desired, for manageability). The use of RAID can greatly simplify the database layout process by providing an abstraction layer above the physical disks while ensuring high performance.

Regardless of the implemented RDBMS and the chosen disk arrangement, be sure that you properly distribute the following types of database objects:

  • Database log or archive files.
  • Temporary workspace used by the database.
  • Tables and Indexes: In most implementations, the tables and corresponding indexes in the following list tend to be some of the more heavily used and must be separated across devices. In general, the indexes listed below must be placed on different physical devices from the tables on which they are created.
    • S_ACCNT_POSTN
    • S_PARTY_REL
    • S_OPTY
    • S_PARTY
    • S_ADDR_ORG
    • S_SRV_REQ
    • S_OPTY_POSTN
    • S_EVT_ACT
    • S_CONTACT
    • S_OPTY
    • S_POSTN_CON
    • S_ORG_EXT
    • S_DOCK_TXN_LOG

     

    NOTE:  If you plan on making extensive use of Siebel EIM, then put the key EIM tables (based on the unique business requirements) and their corresponding indexes on different devices from the Siebel base tables and indexes, because all of them are accessed simultaneously during Siebel EIM operations.

Siebel Performance Tuning Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.