Wednesday, February 20, 2013

4 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

4 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

 

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