Chapter 2 Effective Application Design This chapter describes the most popular types of applications that use Oracle and the features to examine when designing each type of system.
Chapter 4 SQL Processing This chapter explains the steps that Oracle must perform to process the various types of SQL commands.
Chapter 5 The Optimizer: Overview This chapter describes the optimizer, the part of Oracle that chooses the most efficient way to execute each SQL statement, and explains how the optimizer works.
Chapter 6 Parallel Query Option This chapter describes the parallel query option and parallel statement processing.
Chapter 7 Tuning SQL Statements This chapter helps you write SQL statements so they are processed more efficiently by Oracle. This chapter discusses these topics: the optimizer, indexes, clusters, hashing, and hints.
Chapter 9 Tuning I/O This chapter discusses how to avoid I/O bottlenecks that can reduce performance. In this chapter, you learn to reduce disk contention, allocate space in data blocks, and avoid having Oracle manage space dynamically.
Chapter 10 Tuning Contention This chapter discusses the problems caused by contention and helps you recognize when these problems occur. In this chapter, you learn to reduce contention for rollback segments and redo log buffer latches.
Chapter 11 Additional Tuning Considerations This chapter discusses specific performance-related aspects of the Oracle Server, including sorts, free lists, and checkpoints.
Appendix B Statistic Descriptions This appendix briefly describes some of the statistics that can be used for tuning.
Appendix C Operating System-Specific Information This appendix lists parts of the tuning process that vary depending on the operating system you are using. For the actual information for your operating system, see your Oracle operating system-specific documentation.