OCP Blog
Super DBA
Run ADDM Statistic
by vazha mantua Monday, November 8, 2010 11:27 AM

The Automatic Database Diagnostic Monitor (ADDM) analyzes data in the Automatic Workload Repository (AWR) to identify potential performance bottlenecks. For each of the identified issues it locates the root cause and provides recommendations for correcting the problem. An ADDM analysis task is performed and its findings and recommendations stored in the database every time an AWR snapshot is taken provided the STATISTICS_LEVEL parameter is set to TYPICAL or ALL. The ADDM analysis includes

Run ADDM report user can with Oracle Enterprise manager, but there i want tell you about script which provided same information. After running this script in PL/SQL Developer you can get ADDM report result.

1. Report Interval

you should decide on what period do you want see ADDM report, thats why you run this select on DB :

select * from dba_hist_snapshot
order by snap_id

and now you know begin and end snap_id(snap_id_1, snap_id_2)

2. Create ADDM Task

BEGIN
-- Create an ADDM task.
DBMS_ADVISOR.create_task (
advisor_name => 'ADDM', 
task_name => 'Test Report',
task_desc => 'Test Report');

-- Set the start and end snapshots.
DBMS_ADVISOR.set_task_parameter (
  task_name =>'Test Report',
parameter => 'START_SNAPSHOT',
  value => snap_id_1);

DBMS_ADVISOR.set_task_parameter (
  task_name => 'Test Report',
parameter => 'END_SNAPSHOT',
  value => snap_id_2);

-- Execute the task.
DBMS_ADVISOR.execute_task(task_name =>'Test Report');

END;

3. Get Report

SELECT DBMS_ADVISOR.get_task_report('Test Report ','TEXT', 'TYPICAL', 'ALL') AS report
FROM dual;

In BLOB you can see result of report

 

4. Delete Report

for deleting report you can run this statement:

BEGIN
  DBMS_ADVISOR.delete_task ( task_name => 'Test Report');
END;

Tags:

Comments (9) -

9/16/2011 7:53:51 PM #

12 inch subwoofers

Hi. I wanted to drop you a fast be aware to express my thanks. Ive been following your blog for a month or so and have picked up a ton of good info and loved the method youve structured your site. I'm trying to run my very own blog however I believe its too common and I need to focus on a lot of smaller topics. Being all issues to all people isn't all that its cracked as much as be.

12 inch subwoofers United States

10/28/2011 10:55:28 AM #

casino online

Appreciating your own dedication a student place in the person's web site and precise tips a student provide! Thanks considerably for your complete the task you own place in the following posting.

casino online United States

11/18/2011 6:17:35 AM #

Bad credit repair services

Valuable information. Lucky me I found your website by accident, and I am shocked why this accident didn’t happened earlier! I bookmarked it.

Bad credit repair services United States

12/1/2011 5:00:58 PM #

dispute credit

A really well written post, thank you for your hard work, please keep it up

dispute credit United States

12/23/2011 1:07:30 PM #

apple iphone

hi, I wanted to comment on your post  because of its useful information and great read

apple iphone United States

1/17/2012 4:18:07 AM #

electricians Sydney

You can definitely see your enthusiasm in the articles you write. The internet community needs even more passionate writers such as you who are not afraid to mention what they believe.

electricians Sydney United States

6/3/2012 2:24:19 AM #

Directory Submission Service

Run ADDM report user can with Oracle Enterprise manager, but there i want tell you about script which provided same information. After running this script in PL/SQL Developer you can get ADDM report result.

Directory Submission Service United Kingdom

6/10/2012 3:27:04 PM #

Iraqi Dinar

Run ADDM report user can with Oracle Enterprise manager, but there i want tell you about script which provided same information. After running this script in PL/SQL Developer you can get ADDM report result.

Iraqi Dinar United Kingdom

6/20/2012 2:30:35 PM #

Diminished Value

Run ADDM report user can with Oracle Enterprise manager, but there i want tell you about script which provided same information. After running this script in PL/SQL Developer you can get ADDM report result.

Diminished Value United Kingdom

Pingbacks and trackbacks (1)+

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  August 2018  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789

View posts in large calendar

TextBox