Database Tuning (MOSC)

MOSC Banner

Can ADDM Analysis be based on many AWR snapshots, more than just two?

edited Jul 2, 2024 6:16AM in Database Tuning (MOSC) 3 commentsAnswered ✓

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center