CHAPTER 25Performance Tuning
Exam Objectives
In this chapter you will learn to
• 052.13.1 Use Automatic Memory Management
• 052.13.2 Use Memory Advisors
• 052.13.3 Troubleshoot Invalid and Unusable Objects
• 053.14.1 Implement Automatic Memory Management
• 053.14.2 Manually Configure SGA Parameters
• 053.14.3 Configure Automatic PGA Memory Management
• 053.15.1 Use the SQL Tuning Advisor
• 053.15.2 Use the SQL Access Advisor to Tune a Workload
• 053.15.3 Understand Database Replay
Performance management is a huge subject. The treatment given in the core OCP syllabus is little more than an introduction. There is an additional qualification (the “Oracle Database 11g Performance Tuning Certified Expert”) that requires passing another exam that takes ...
Get OCA/OCP Oracle Database 11g All-in-One Exam 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.