Bookshelf Home | Contents | Index | Search | PDF |
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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Performance Tuning Guide Published: 18 April 2003 |