Undo Advisor 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; |