This chapter provides information about how to tune the database server memory, I/O, and general resource use.
You tune the database server differently for DSS and OLTP applications. Because DSS applications are bandwidth intensive, you tune memory to increase the number of megabytes processed per second. Throughput-intensive OLTP applications require you to maximize I/O per second.
The same database server cannot provide optimum performance for both DSS and OLTP applications. If your database server hosts an operational data store (ODS) that is used by both OLTP-like and DSS-like applications, consider the various methods of adjusting performance for specific sessions, as described in Managing Resource Use for Specific Sessions. For additional information about tuning applications themselves, see Tuning Specific Queries and Transactions.
This chapter contains the following major sections:
For information about tuning the configuration parameter that determine virtual processor and CPU use, see Tuning CPU-Management Parameters.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]