Summary
In this chapter, we've examined the concept of performance management in the Oracle database. We've examined object-level tuning using strategies to manage optimizer statistics and recompile invalid objects. We've explored the Automatic Workload Repository or AWR and used it to generate reports that can reveal statistics about database performance. We've looked at the 11g Advisory Framework and ADDM, which can give relevant performance advice to DBAs based on the statistics it has collected. We've examined how thresholds and alerts can be used to proactively notify us when problems arise. Finally, we've examined all the three methods of memory management, namely, manual, ASMM, and AMM. In our next chapter, we begin a section that addresses ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide 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.
