WA1386 Oracle Database 10g: SQL Tuning Course Outline   1. CONTEMPLATING THE TUNING ISSUES DIFFERENCES BETWEEN APPLICATIONS THE CHALLENGES OF TUNING THE IMPACT OF THE SYSTEMS INFRASTRUCTURE USING THE MANAGEMENT & ADVISORY FRAMEWORK 2. SQL STATEMENT EXECUTION THE EXECUTION PHASES SQL EXECUTION MODES 3. VIEWING THE EXECUTION PLAN MORE ABOUT THE EXECUTION PLAN VIEWING THE EXECUTION PLAN MORE INTERPRETATION OF THE PLAN 4. UNDERSTANDING THE COST BASED OPTIMIZER (CBO) OPTIMIZATION GOALS CBO COMPONENTS 5.OPTIMIZER OPERATIONS TABLE ACCESS OPERATIONS JOIN OPERATIONS INDEX OPERATIONS 6.MANAGING OPTIMIZER STATISTICS MORE ABOUT OPTIMIZER STATISTICS AUTOMATIC DATABASE STATISTICS COLLECTION MANUALLY GATHERING STATISTICS USING THE DBMS_STATS() PACKAGE USING THE EM INTERFACE COLLECTING & MANAGING SYSTEM STATISTICS MANAGING SYSTEM STATISTICS 7. PERFORMANCE MONITORING & PROACTIVE MAINTENANCE THE MANAGEMENT & ADVISORY FRAMEWORK REAL-TIME MONITORS MANAGING THE AUTOMATIC WORKLOAD REPOSITORY AUTOMATIC DATABASE DIAGNOSTIC MONITOR METRICS & ALERT THRESHOLDS 8. USING ADDM & THE SQL TUNING ADVISOR APPLICATION TUNING SETUP APPLICATION MONITORING & TUNING WITH EM SQL TUNING ADVISOR 9. PROGRAMMATIC ACCESS TO THE SQL TUNING ADVISOR ABOUT SQL TUNING ADVISOR TASKS SQL PROFILE MANAGEMENT SQL TUNING SET MANAGEMENT 10. USING THE SQL ACCESS ADVISOR USING THE SQL ACCESS ADVISOR PERFORMING A QUICK TUNE TASK INDEX OPERATION DATABASE PARAMETERS 11. OPTIMIZER HINTS ABOUT HINTS HINT EXPLANATIONS 12. HISTOGRAMS WHY ARE HISTOGRAMS NEEDED? HISTOGRAMS INTERNAL STRUCTURE MANUALLY MANAGING HISTOGRAMS 13. USING PLAN STABILITY ABOUT PLAN STABILITY PREPARING FOR STORED OUTLINES CREATING & USING STORED OUTLINES DATA DICTIONARY STORAGE MANAGING STORED OUTLINES 14. EDITING PRIVATE OUTLINES ABOUT PRIVATE OUTLINES EDITING PRIVATE OUTLINES UTILIZING PRIVATE OUTLINES 15. EXPLOITING & MANAGING CURSOR SHARING ABOUT CURSOR SHARING BIND VARIABLES & CURSOR PEEKING USING THE CURSOR_SHARING PARAMETER 16. USING TKPROF & AUTOTRACE USING TKPROF USING AUTOTRACE 17. MANAGING SCHEMA OBJECTS ABOUT CHAINED & MIGRATED ROWS VALIDATING DATABASE OBJECTS