UNDO ADVISOR - 10g
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;
 

Advertentie

>

Poll

Voorkeur
 

Wie is er aanwezig

We hebben 162 gasten online