Oracle 18c SQL Performance Tuning Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français - Veuillez noter que ce cours est uniquement disponible en anglais. This Oracle 18c SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is de Oracle 18c SQL Performance Tuning Training Course Course Contents - DAY 1 Course Introduction Administration and Course Materials Course Structure and Agenda Delegate and Trainer Introductions Session 1: INTRODUCTION TO ORACLE PERFORMANCE TUNING Overview of Oracle Database Tuning Application Developer Tuning Responsibilities Oracle DBA Tuning Responsibilities Oracle Tuning Process Plan a Routine Monitoring Regime Setting Suitable Goals Syntax Considerations Session 2: TOOLS FOR EVALUATING SQL STATEMENTS Overview of SQL Statement Tuning Tools to Assist in SQL Tuning Use Explain Plan,Autotrace and SQL Trace to Examine the Execution of a SQL Statement Interpreting a SQL Trace Session 3: THE SQL OPTIMIZER The SQL Optimizer Statement
