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.