Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Database Parameters and Requirements for Siebel Data Warehouse >

Additional Suggestions for Optimizing Oracle Performance in Siebel Data Warehouse

---

• Siebel eBusiness Applications under Oracle support only binary sorting. If you are running an Oracle client, do one of the following:
  • Set the NLS_SORT parameter to BINARY.
  • Choose a NLS_LANG setting that includes binary.

    These settings are required for adequate performance from the Dedicated Web Client.

• Make sure that cost-based optimization is enabled in the Oracle development, test, and production databases and that statistics are kept up to date. Otherwise, the rule-based optimizer may be used.
• Create foreign keys in the Oracle database, but configure Oracle to not enforce the foreign key relationship. The existence of foreign keys will allow Oracle to better optimize certain queries. By turning off enforcement, the database load should not be negatively affected.
  • In addition, you may also configure the Oracle star-join transformation. This requires non-enforced foreign keys in Oracle and the creation of necessary bitmap indices. This task is optional. It may not be necessary, as ongoing tuning may reach the desired performance goals.
• Analyze application for occurrences of highly skewed data that is indexed. Create histogram statistics for these indices to enable the optimizer to better
• To increase data throughput between Siebel Analytics Server and Oracle, change SDU and TDU settings in listener.ora. The default is 2 KB and can be increased to 8 KB.
• On the server side, edit the listener.ora file. Under the particular SID_LIST entry, modify SID_DESC as follows:

  SID_LIST_LISTENER =

  SID_LIST =

  SID_DESC = (SDU=8192)(TDU=8192)

     ORACLE_HOME = /.....)

     SID_NAME = SOLAP)

  )

  )

• On the client side, edit the tnsnames.ora file. Modify the TNS alias by adding SDU= and TDU= as follows:

  myhost_orcl.world=

  DESCRIPTION=(SDU=8192)(TDU=8192)

  ADDRESS = (PROTOCOL = TCP)(HOST=myhost)(PORT=1521))

  CONNECT_DATA=(SID=ORCL))

  )

Bookshelf Home | Contents | Index | Search | PDF