| Segment advisor problem [message #218701] |
Fri, 09 February 2007 06:53 |
mitra.kausik
Messages: 21
Registered: June 2006
|
Junior Member |
|
|
Can anybody please tell me what is worng with the following code or what do I need to do to get dbms_advisor work?
declare
name varchar2(100);
descr varchar2(500);
obj_id number;
task_id number;
begin
name:= '';
descr:='checking Histcalls';
dbms_advisor.create_task
('Segment Advisor',task_id,name,descr,NULL);
dbms_advisor.create_object
(name,'TABLE','km','HISTCALLS',NULL,NULL,obj_id);
dbms_advisor.set_task_parameter(name,'RECOMMEND_ALL','TRUE');
dbms_advisor.execute_task(name);
dbms_output.put_line('Number is '|| task_id);
end;
/
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at line 14
/
My objective is to collect segment advices for the above mentioned table.
Based on the task_id I will query dba_advisor_findings to make sure if any shrinkage is required for the above table.
Thanks and Regards
[Updated on: Fri, 09 February 2007 06:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
