Curriculum
- 1 Section
- 13 Lessons
- 4 Days
Expand all sectionsCollapse all sections
- Topics13
- 1.1TUNING & THE ORACLE DATABASE ADVISORY FRAMEWORK THE challenges of tuning PERFORMANCE metrics MANAGEMENT & advisory framework ADDM & AWR SQL tuning privileges
- 1.2VIEWING & MONITORING THE EXECUTION PLAN ABOUT the execution plan COLLECTING performance statistics VIEWING the execution plan REAL-TIME SQL monitoring
- 1.3UNDERSTANDING THE OPTIMIZER OPTIMIZATION methods OPTIMIZATION goals OPTIMIZER_MODE OPTIMIZER_FEATURES_ENABLE OPTIMIZER components EXECUTION plan operators
- 1.4EXECUTION PLAN METHODS & OPERATORS TABLE access methods JOIN methods INDEX operations DATA operations
- 1.5MANAGING OPTIMIZER STATISTICS MORE about optimizer statistics AUTOMATIC maintenance tasks MANUALLY gathering statistics GATHER_TABLE_STATS() GATHER_INDEX_STATS() GATHER_SCHEMA_STATS() GATHER_DATABASE_STATS() GATHER_SYS parameter GATHER_DICTIONARY_STATS() GATHER_DATABASE_STATS() USING historical statistics DYNAMIC sampling LOCKING statistics
- 1.6ENHANCED OPTIMIZER STATISTICS ABOUT optimizer system statistics MANAGE system statistics CREATE_STAT_TABLE(), DROP_STAT_TABLE() CREATE_STAT_TABLE() DROP_STAT_TABLE() GATHER_SYSTEM_STATS() GET_SYSTEM_STATS() SET_SYSTEM_STATS() IMPORT_SYSTEM_STATS(), EXPORT_SYSTEM_STATS() IMPORT_SYSTEM_STATS() EXPORT_SYSTEM_STATS() DELETE_SYSTEM_STATS() PENDING & PUBLISHED STATISTICS
- 1.7HISTOGRAMS & EXTENDED STATISTICS WHY are histograms needed? HISTOGRAMS internal structure MANUALLY managing histograms EXPRESSION statistics MULTICOLUMN statistics
- 1.8APPLICATION TRACING APPLICATION tracing packages SET_SQL_TRACE() TRACE_ENABLE() SET_IDENTIFIER() EM application monitoring & tuning REAL-TIME monitoring USING TRCSESS & TKPROF
- 1.9ADDM & THE SQL TUNING ADVISOR ADDM performance analysis USING the SQL tuning advisor AUTOMATIC SQL tuning CONFIGURING automatic SQL tuning
- 1.10THE SQL ACCESS ADVISOR USING the SQL access advisor SQL access advisor templates PERFORMING a quick tune task USING the SQL access advisor INDEX database parameters OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING SKIP_UNUSABLE_INDEXES OPTIMIZER_USE_INVISIBLE_INDEXES
- 1.11PLAN MANAGEMENT SQL management base architecture LOAD_PLANS_FROM_SQLSET() LOAD_PLANS_FROM_CURSOR_CACHE() USING plan baselines PLAN management using EM
- 1.12MANAGING CURSOR SHARING ABOUT cursor sharing BIND variables & cursor sharing THE cursor_sharing parameter FINDING candidates for rewrite
- 1.13OPTIMIZER HINTS WHAT are hints? HINT explanations
ENHANCED OPTIMIZER STATISTICS ABOUT optimizer system statistics MANAGE system statistics CREATE_STAT_TABLE(), DROP_STAT_TABLE() CREATE_STAT_TABLE() DROP_STAT_TABLE() GATHER_SYSTEM_STATS() GET_SYSTEM_STATS() SET_SYSTEM_STATS() IMPORT_SYSTEM_STATS(), EXPORT_SYSTEM_STATS() IMPORT_SYSTEM_STATS() EXPORT_SYSTEM_STATS() DELETE_SYSTEM_STATS() PENDING & PUBLISHED STATISTICS
Prev
APPLICATION TRACING APPLICATION tracing packages SET_SQL_TRACE() TRACE_ENABLE() SET_IDENTIFIER() EM application monitoring & tuning REAL-TIME monitoring USING TRCSESS & TKPROF
Next