Siebel Analytics Performance Tuning Guide > The Database Servers > Computer Host >

Miscellaneous Tips


Another thing you can do to increase the performance of queries is measure how many users you will have, or more correctly, how many sessions in the database you will have at any given time. Then see how much memory is on the available server, and set the values for SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE rather high. 20, 30 or 40 MB per session is not uncommon in a data warehouse situation. Also set HASH_AREA_SIZE rather large.

Never use Oracle MTS (multi-threaded server) for an OLAP DSS type database, it does not lend itself well, as the one long-running process will consume shared server resources and slow down all others. In this case, dedicated connections is without any doubt the way to go.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003