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

Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

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

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback