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

Опубликовано: 04 Май 2023
на канале: Anish kumar

2,039

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:
https://asrblogger.com/oracle-awr-aut...
https://asrblogger.com/ash-active-ses...

For more Information Visit:
https://asrblogger.com/
Join Telegram : https://t.me/asrBlogger
Scripts from Github : https://github.com/anishs10/db-scripts

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