• Arun Kumar

Oracle ADDM Report

  • It analysis AWR report to identify potential performance bottle neck.

  • For each identified issue, it locates the root cause and provides recommendations.

  • It is created and stored every time AWR report is run provided STATISTICS_LEVEL parameter is set to TYPICAL or ALL.

To create ADDM Report:


@$ORACLE_HOME/rdbms/admin/addmrpt.sql

Sample output of ADDM report:


FINDING: 59% impact (944 seconds)

  • The buffer cache was undersized causing significant additional read I/O.


RECOMMENDATION 1: DB Configuration, 59% benefit (944 seconds)

  • ACTION: Increase SGA target size by increasing the value of parameter   “sga_target” by 28 M.


SYMPTOMS THAT LED TO THE FINDING:

  • Wait class “User I/O” was consuming significant database time. (83% impact [1336 seconds])

222 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis