Chapter 9
Tuning an Oracle Database for Performance
In This Chapter
Knowing the tuning tools and techniques
Tuning before a problem occurs
Tuning after a problem occurs
Tuning SQL
Tuning the database
Tuning an Oracle database is one of the most challenging activities you encounter as a database administrator. Heck, we could probably write an entire book on the tools Oracle provides and the methodologies you can use when tackling a database performance issue. Knowing the tools and techniques will get you a long way, but the problems DBAs uncover also require an understanding of basic computer functionality and cooperation with other members of the infrastructure management team within your organization.
In this chapter, we explore the tuning methods an experienced database administrator might employ. We introduce you to concepts of performance tuning and provide some fundamental techniques that will allow you to take advantage of what Oracle has to offer before you even begin to install ...
Get Oracle® 12c For Dummies® 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.
