De Undo Advisor in de Enterprise (Home > Advisor Central > Undo Management > Undo Advisor)

Maakt aanbevelingen voor undo configuraties. De Undo Advisor is ook toegankelijk vanuit PL/SQL middels de package DBMS_ADVISOR, maar geen van de reporting procedures steunt deze adviseur zodat u de aanbevelingen van de DBA_ADVISOR_% views handmatig moet ophalen:

SELECT MIN(snap_id), MAX(snap_id) FROM dba_hist_snapshot;

MIN(SNAP_ID) MAX(SNAP_ID)
------------ ------------
884 1052

1 row selected.

DECLARE
l_task_name VARCHAR2(30) := '884_1052_AWR_SNAPSHOT_UNDO';
l_object_id NUMBER;
BEGIN

Creeer een ADDM taak.

DBMS_ADVISOR.create_task (
advisor_name => 'Undo Advisor',
task_name => l_task_name,
task_desc => 'Undo Advisor Task');

DBMS_ADVISOR.create_object (
task_name => l_task_name,
object_type => 'UNDO_TBS',
attr1 => NULL, 
attr2 => NULL, 
attr3 => NULL, 
attr4 => 'null',
attr5 => NULL,
object_id => l_object_id);

Zet de target object.

DBMS_ADVISOR.set_task_parameter (
task_name => l_task_name,
parameter => 'TARGET_OBJECTS',
value => l_object_id);

Zet de start en eind snapshots.

DBMS_ADVISOR.set_task_parameter (
task_name => l_task_name,
parameter => 'START_SNAPSHOT',
value => 884);

DBMS_ADVISOR.set_task_parameter (
task_name => l_task_name,
parameter => 'END_SNAPSHOT',
value => 1052);

Execute de taak.

DBMS_ADVISOR.execute_task(task_name => l_task_name);
END;