The Oracle Database 19c: Performance Management and Tuning OCP has demonstrated a strong understanding of performance analysis, management and tuning for optimal performance of an Oracle Database environment. They can apply a database tuning methodology by using the appropriate tools in order to monitor, diagnose and tune instance and SQL performance problems. This candidate possesses a profound knowledge of the Oracle Database architecture, great familiarity with day-to-day database administration, knowledge of which advisors can be used to inspect various aspects/areas of the Oracle Database environment, and a good working knowledge of SQL, its executions plans and generated statistics.

• Describe Performance Management
• Use AWR Performance Statistics
• Use AWR Based Tools
• Improve SQL Statement Performance
• Influence the Optimizer
• Use Tuning Analyzers and Advisors
• Monitor Operations and applications
• Manage Memory
• Manage Database Memory
• Use In-Memory Column Store Feature

• Overview　
• Defining the Scope of Performance Issues　
• Using the Time Model to Diagnose Performance Issues　
• Using Statistics and Wait Events to Diagnose Performance Issues

• Using Log and Trace Files to Monitor Performance　
• Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance　
• Using Statspack to View Performance Data　
• Using Automatic Workload Repository　
• Using Metrics and Alerts　
• Using Baselines

• Managing Automated Maintenance Tasks　
• Using ADDM to Analyze Performance　
• Using Active Session History Data for First Fault System Analysis　
• Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues　
• Overview of SQL Statement Processing　
• Maintaining Indexes　
• Maintaining Tables
• Introduction to Query Optimizer
• Understanding Execution Plans　
• Viewing Execution Plans by Using SQL Trace and TKPROF
• Managing Optimizer Statistics
• Using Automatic SQL Tuning
• Using the SQL Plan Management Feature　
• Overview of the SQL Advisors　
• Using the SQL Tuning Advisor
• Using the SQL Access Advisor
• Overview of Real Application Testing Components　
• Using SQL Performance Analyzer to Determine the Impact of Changes
• Using Database Replay to Test System Performance　
• Implementing Real-Time Database Operation Monitoring　
• Using Services to Monitor Applications
• Overview of Memory Structures
• Managing Shared Pool Performance
• Managing Buffer Cache Performance　
• Managing PGA and Temporary Space Performance
• Configuring the Large Pool　
• Using Automatic Shared Memory Management　
• Introduction to In-Memory Column Store　
• Configuring the In-Memory Column Store Feature

• Using the In-Memory Column Store Feature to Improve SQL Performance
• Using In-Memory Column Store with Oracle Database Features