Skills
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.
Performance
Tuning
Monitoring
Execution Plan
SQL Trace
Optimizer
Diagnostics
SQL Performance Analyzer
SQL
Profiles
Advisors
Database Replay
PGA Automatic (Shared) Memory Management