Oracle Database 12c The Complete Reference

CHAPTER46The 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 application performance must be part of the design process.

This chapter describes the major new tuning changes introduced ...