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

[suryakolla]

Thanks Arun.! for uploading this kind of videos..its really useful for easily understand the oracle performance tuning..

[navin]

Good Arun...I'm a great fan of u...for ur simplified learning method...if possible can u show these methods in practical...session..

[rjnuguid]

Do you know any tool wherein you can simply put a query and analyze if the query and gives a grade if the query is good or not? Thank you.