Learn how to use Oracle ADDM and ASH Report to Diagnose and Fix Performance issues in Database.

ADDM (Automatic Database Diagnostic Monitoring) Report:
Automatic Database Diagnostic Monitoring Report analyzes the AWR data on a regular basis, to give you overview of the root cause of the problem which is affecting your database’s performance. It also provides suggestions or recommendations for rectifying any problem identified and lists the areas which are having no issues.

ASH (Active Session History) Report:
Active Session History Reports shows you Transient performance problems (usually not captured in ADDM reports) and Time / session / action /module / SQL_ID based target performance analysis stats regarding your Oracle Database.

Sample AWR & ASH Report Link:

For more Information Visit:

#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba

[avnishsingh]

Really helpful for people in Oracle DB Industry ;)

[susovanroy]

Thank you for making this video this is really helpful and the way of your teaching is really helped me a lot

[satyakiroygosthipaty]

Thank you Anish sir. This information is much required for clear understanding of all the reports.

[chakshujain]

Hi Anish,

Could you please make a video on SQL Profile and SQL plan baselines.
Thank you in advance.

[santoshpanigrahi]

Hi Anish. Could you add those files in description. Thank you