• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » How to create ADDM task and check its report

How to create ADDM task and check its report

June 16, 2014 by techgoeasy Leave a Comment


In this post, I will explain How to create ADDM task  and check its report
We are using start snapshot as 900
And end snapshots as 950

BEGIN
— Create an ADDM task.
DBMS_ADVISOR.create_task (
advisor_name      => ‘ADDM’,
task_name         => ‘900_950_AWR_SNAPSHOT’,
task_desc         => ‘Advisor for snapshots 900 to 950.’);
— Set the start and end snapshots.
DBMS_ADVISOR.set_task_parameter (
task_name => ‘900_950_AWR_SNAPSHOT’,
parameter => ‘START_SNAPSHOT’,
value     => 900);
DBMS_ADVISOR.set_task_parameter (
task_name => ‘900_950_AWR_SNAPSHOT’,
parameter => ‘END_SNAPSHOT’,
value     => 950);
— Execute the task.
DBMS_ADVISOR.execute_task(task_name => ‘900_950_AWR_SNAPSHOT’,);
END;
/
— Display the report.
SET LONG 100000
SET PAGESIZE 50000
SELECT DBMS_ADVISOR.get_task_report(‘900_950_AWR_SNAPSHOT’) AS report
FROM   dual;
SET PAGESIZE 24

Related Views
The following views can be used to display the ADDM output without using Enterprise Manager or the GET_TASK_REPORT function:
DBA_ADVISOR_TASKS – Basic information about existing tasks.
DBA_ADVISOR_LOG – Status information about existing tasks.
DBA_ADVISOR_FINDINGS – Findings identified for an existing task.
DBA_ADVISOR_RECOMMENDATIONS – Recommendations for the problems identified by an existing task.


Filed Under: Oracle, Oracle Database Tagged With: addm report, How to create ADDM task and check its report

Reader Interactions

Leave a Reply Cancel reply

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • EBS PDB service name disappear from listener in 19c
  • how to download oracle e-business suite 12.2 software
  • Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)
  • Step by step upgrade process for R12.2 Upgrade Part -1
  • Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.x Release Update Pack)

Copyright © 2021 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us