O'Reilly logo

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition by Bob Bryla, Roopesh Ramklass, John Watson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Images

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required