ADDM Report Generation

We can use

1. select date and time

select  snap_id || '=' || dbid || '=' || instance_number || '=' || to_char(end_interval_time, 'DD/MON/YYYY HH24:MI:SS')  as addmreport from    dba_hist_snapshot order by end_interval_time desc;

2.

BEGIN
  -- Create an ADDM task name.
  DBMS_ADVISOR.create_task (
    advisor_name      => 'ADDM',
    task_name         => '<begin_snapid>_<end_snap_id>_<name>',
    task_desc         => '<some text>');

  -- Set the start snap_id.
  DBMS_ADVISOR.set_task_parameter (
    task_name => '<begin_snapid>_<end_snap_id>_<name>',
    parameter => 'START_SNAPSHOT',
    value     => <begin_snapid>);

-- Set the end snap_id.
  DBMS_ADVISOR.set_task_parameter (
    task_name => '<begin_snapid>_<end_snap_id>_<name>',
    parameter => 'END_SNAPSHOT',
    value     => <end_snap_id>);

  -- Execute the task.
  DBMS_ADVISOR.execute_task(task_name => '<begin_snapid>_<end_snap_id>_<name>');
END;
/