Database Performance Tuning Tools | Oracle Performance Tuning

This video describes new #performance #tuning features of #Oracle #Database 12c Release 2 (12.2) and provides pointers to additional information. The features and enhancements described in this video comprise the overall effort to optimize database performance.

00:00 SQL Tuning Tools
00:36 Automatic Tools
01:37 Automatic Database Diagnostic Monitor (ADDM)
02:18 AWR report
04:08 SQL Tuning Advisor
04:43 SQL Access Advisor
05:54 Active Session History (ASH) report
06:42 SQL Plan Management
07:04 SQL Performance Analyzer
07:37 Manual Tools
08:06 Execution plan
12:19 TKPROF Utility
12:44 Hints

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis