• 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, ...