Chapter 12. Making Things Run Fast (Enough)

Tuning a database is an ongoing job for the busy DBA. Users never seem to stop complaining about queries running slowly. And once you think that everything is at peak performance, a new application is added to the mix, a new server is added to the server pool, the volume of orders for widgets doubles mysteriously, or a data warehouse is using up more and more of the server's resources.

In this chapter, we'll talk about several ways to optimize the performance of the database, beginning with Oracle's Tuning Methodology. Then we'll cover indexes, data design tuning, application tuning, and memory tuning.

Get Oracle Database Foundations 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.