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

Guidelines for Ongoing Oracle Administration

After your Siebel eBusiness Applications installation is up and running, monitor the following areas on a regular basis:

• Insertion rates on tables. You will probably want to set the INI_TRANS value for tables with high insertion rates to a value higher than 1; a typical setting is 4.

  This parameter determines how many simultaneous inserts can occur on the database blocks that store data for those tables and, therefore, can affect performance in an intensive data-entry environment. Use multiple freelists for the table S_DOCK_TXN_LOG, because this table receives numerous inserts.

• SGA cache hits. Determine whether SGA parameters need to be adjusted for your system.
• The extents used by each object. A large number of extents on a table or index creates response time degradation for transactions that access the table or index.
• Siebel tables that are subject to frequent INSERT and DELETE operations. This transaction mixture can cause some databases to become fragmented over time.

  You should monitor the space utilization and fragmentation of these tables and perform regular database maintenance procedures as recommended by your database vendor. The following list contains the names of the tables you should monitor.

  S_DOCK_TXN_LOG
  S_DOCK_TXN_LOGT
  S_DOCK_TXN_SET
  S_DOCK_TXN_SETT
  S_DOCK_INST
  S_DOCK_INIT_ITEM

• Rollback segments. Make sure that you have enough segments available and that they are the optimum size for the most common operations.