CHAPTER 43The Hitchhiker’s Guide to Tuning Applications and SQL

With each new release of its products, Oracle adds features to enhance the performance of your applications. These features may include new options that you must manually implement (such as partitioning) or under-the-cover changes that provide a performance benefit without your making any changes to your application.

Do not approach tuning as something done after an application goes into production, or after a system test has been performed. As you will see, planning for the performance of an application must be part of the design process.

In this chapter, you will see a description of the major new tuning changes introduced with Oracle Database 10g. A set of guidelines and best ...

Get Oracle Database 10g The Complete Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.