Home » RDBMS Server » Server Administration » Segment advisor problem
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

Previous Topic: Metrics "Current Open Cursors Count" is at 7057
Next Topic: Reg Buffers
Goto Forum:
  


Current Time: Fri Dec 09 17:43:28 CST 2016

Total time taken to generate the page: 0.17898 seconds