Can ADDM Analysis be based on many AWR snapshots, more than just two?
Can ADDM Analysis be based on many AWR snapshots, more than just two?
I'm thinking of this code, is it based on two AWR snapshots, snapshot id 20 and snapshot id 30, Or is it based on all snapshots between 20-30?
Something in my mind says ADDM analysis should be based on two AWR snapshots but now I have doubts.
Thank you
BEGIN
DBMS_ADVISOR.CREATE_TASK (
ADVISOR_NAME => 'ADDM',
TASK_NAME => 'name123_HELLO',
TASK_DESC => 'Hello World!');
DBMS_ADVISOR.SET_TASK_PARAMETER (
TASK_NAME => 'name123_HELLO',
PARAMETER => 'START_SNAPSHOT', VALUE => 20);
DBMS_ADVISOR.SET_TASK_PARAMETER (
TASK_NAME => 'name123_HELLO',
PARAMETER => 'END_SNAPSHOT', VALUE => 30);