如何手工执行segment advisor(10g/11g)

begin
declare
id number;
name varchar2(100);
descr varchar2(500);
obj_id number;
begin
name:='Manual_Employees';
descr:='Segment Advisor Example';
dbms_advisor.create_task(advisor_name => 'Segment Advisor',task_id => :id,task_name => name,task_desc => descr);
dbms_output.put(id);


dbms_advisor.create_object(task_name => name,object_type => 'TABLE',attr1 => 'SAJET',attr2 => 'g_test_result',attr3 => NULL,attr4 => NULL,attr5 => NULL,object_id => obj_id);




dbms_advisor.set_task_parameter(task_name => name,parameter => 'recommend_all',value => 'TRUE');


  end;

end;

执行完毕之后会打印出task id ，以此task id来查找其他信息：

DBA_ADVISOR_*

查看结果：

select tablespace_name, segment_name, segment_type, partition_name,
recommendations, c1 from
table(dbms_space.asa_recommendations('FALSE', 'FALSE', 'FALSE'));