Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for Microsoft Windows > Creating the Oracle Database >

Ongoing Oracle Database 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.

It is recommended that you use multiple freelists for the table S_DOCK_TXN_LOG, since 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.

Bookshelf Home | Contents | Index | Search | PDF