Oracle7 Server Tuning
Tuning While Designing and Developing a System
Well designed systems can prevent performance problems later in the life of an application. System designers and application developers must understand Oracle's query processing mechanism to write effective SQL statements. Chapter 2, "Effective Application Design", discusses various configurations for your system and which applications are best suited for each configuration. Chapter 5, "The Optimizer", discusses Oracle's query optimizer and how to write statements that achieve the fastest results.
When designing your system, use the following guidelines for optimal performance:
- Eliminate unnecessary network traffic in client/server applications.
- Use the appropriate Oracle Server options (for example, parallel query or distributed database) for your system.
- Use default Oracle locking unless your application has specific needs.
- Register application modules with the database so that you can track performance on a per-module basis.
- Choose the best size for your data blocks.
- Distribute your data so that the data a node uses is stored locally on that node.
Chapter 2 and Chapter 5 discuss database design issues more completely. Refer to those chapters before building your applications.