Oracle Essentials, 5th Edition

Chapter 7. Oracle Performance

This book illustrates the wide range of features that the Oracle Database has. As you gain experience with Oracle, you’ll reap more of the benefits it has to offer. One area on which you will eventually focus is performance tuning, since you will inevitably be forced to wring additional performance from your Oracle Database in the face of increasing demands. This chapter covers the basics you’ll need to understand as you address performance.

Oracle Database performance tuning has been extensively documented in the Oracle community. There are numerous books that provide detailed and excellent information. This book is focused more on the concepts of the Oracle Database, so we won’t delve too deeply into specific tuning recommendations. Instead, we’ll touch on the importance of tuning and discuss some basic notions of how Oracle uses resources. Here, we’re simply laying a foundation for understanding Oracle performance. This understanding will help you implement the tuning procedures most suited for your own particular implementation. Where appropriate, we’ll provide some basic guidance on how the latest Oracle Database features and Enterprise Manager help you manage performance.

Performance is one of the trickiest aspects in the operation of your database since so many factors can be involved. There is the Oracle Database, to be sure. But there are also platform deployment strategies to consider. Today, the infrastructure for your applications likely resides ...