Wednesday, February 20, 2013

14 Automatic Database Diagnostic Monitor (ADDM)

Whenever MMON take the snapshot from V$AVTIVE_SESSION_HISTORY, it also trigger the ADDM job to compare the 2 previous snapshot and generate the  ADDM report.

 

View the ADDM

select task_name,description,created,status
from dba_advisor_tasks
where advisor_name ='ADDM'
order by created;

image

Create ADDM report

From script

@$ORACLE_HOME/rdbms/admin/addmrpt.sql

From SQL

exec DBMS_ADVISOR.create_task ( advisor_name => 'ADDM', task_name => 'TEST_TASK1',task_desc => 'Advisor for snapshots 78 to 81');
exec DBMS_ADVISOR.set_task_parameter (task_name => 'TEST_TASK1',parameter => 'START_SNAPSHOT', value     => 78);
exec DBMS_ADVISOR.set_task_parameter (task_name => 'TEST_TASK1',parameter => 'END_SNAPSHOT',value     => 81);
exec DBMS_ADVISOR.execute_task(task_name => 'TEST_TASK1');

image

View the ADDM report

 

SET LONG 100000
SET PAGESIZE 50000
select  dbms_advisor.get_task_report('ADDM:2102609525_1_72') AS report FROM   dual;

image

We can also see the ADDM report from OEM

image

image

OEM Cloud Control also can view the real time ADDM.

image

image

14 comments:

  1. Thanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks, I’ll probably keep it short and sweet and link to this instead if thats cool. Thanks. revs

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. The cardio rate monitor is particularly useful for competitors who like to follow all their details.https://bestmonitorhub.com/

    ReplyDelete
  4. This information is meaningful and magnificent which you have shared here about this topic.I am impressed by the details that you have shared in this post and It reveals how nicely you understand this subject. best database provider company in india

    ReplyDelete
  5. There are a few things that you should think about great versatile child screen so you can pick the best on the lookout. http://beitragpost.com/best-portable-monitor-2021-usb-screens-for-working-from-home/

    ReplyDelete
  6. I read your post and got it quite informative. I couldn't find any knowledge on this matter prior to. I would like to thanks for sharing this article here.automatic deck mounted soap dispenser

    ReplyDelete
  7. After reading your blog I think you have good information. I would like to share this information with my friends who need this. Thanks for this blog. Fetal Photos

    ReplyDelete
  8. Long gone are the days when watching movies or playing video games in the car were just for your kids. With the plethora of car video Best Monitor options now available, older "kids" can enjoy themselves during long rides as well.

    ReplyDelete
  9. it also trigger the ADDM job to compare the 2 previous snapshot and generate the ADDM report. Diagnostic Monitor (ADDM) Whenever MMON take the snapshot from V$AVTIVE_SESSION_HISTORY,

    ReplyDelete
  10. Your blog had very good knowledge and that gives huge instructions and that was really commendable ideas you have good knowledge on this topic please share more information with us. shop dieselschrauber

    ReplyDelete
  11. In Best Monitor, you can find articles, tutorials, and reviews on a wide variety of monitors and tech-related products, which will attract buyers of all kinds:

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates