This chapter discusses how the combination of operating-system and database server configuration parameters can affect CPU utilization. This chapter also discusses the parameters that most directly affect CPU utilization and describes how to set them. When possible, this chapter also describes considerations and recommends parameter settings that might apply to different types of workloads.
Multiple database server instances that run on the same host computer perform poorly when compared with a single database server instance that manages multiple databases. Multiple database server instances cannot balance their loads as effectively as a single database server. Avoid multiple residency for production environments in which performance is critical.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]