• 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])

288 views

Recent Posts

See All

Reclaim Unused Space in Oracle

Over a period of time, updates and deletes on objects within a tablespace can create pockets of empty space that individually are not large enough to be reused for new data. This type of empty space i

SQL Data-Type conversion functions

SQL conversion functions are single row functions designed to alter the nature of the data type of a column value, expression, or literal. TO_CHAR, TO_NUMBER, and TO_DATE are the three most widely use

Automatic SQL Tuning in Oracle

Database optimizer runs very fast and must select the best execution plan for a query within fraction of seconds. Due to time constraint (under normal query execution), sometimes optimizer will choose