CHAPTER 19
Performance Tuning
Exam Objectives
• 062.11.1 Use Enterprise Manager to Monitor Performance
• 062.11.2 Use Automatic Memory Management
• 062.11.3 Use the Memory Advisor to Size Memory Buffers
• 062.12.1 Manage Optimizer Statistics
• 062.12.2 Use the SQL Tuning Advisor
• 062.12.3 Use the SQL Access Advisor to Tune Workload
Performance tuning is a huge subject. The treatment given in the core Oracle Certified Professional (OCP) syllabus is little more than an introduction. As an Oracle database administrator (DBA), you will study performance monitoring and enhancement techniques throughout your whole career. Indeed, ...
Get OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition 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.
