Chapter 8. 11g Tuning Tools
Here we are, at the last chapter of this book. It is intended to be the culmination of all the knowledge from the previous chapters. What this chapter provides is details on how to start tuning as a DBA—what is most important to know, how to find that information, and what tools are provided in 11g for preventing and resolving performance issues. The new SQL Plan Management features are covered, along with a recommended migration path for upgrading the query optimizer while keeping performance disruptions to a minimum.
There are two components to tuning: proactive and reactive. Proactive tuning includes an assessment of the current conditions—end user response time, server resources, automatic or manual tuning jobs, ...
Get Oracle Database 11g—Underground Advice for Database Administrators 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.
