I/O na tabela

[Anônimo]

vc pode começar com (se vc tiver a licença dos Advisors), rodando o segment Advisor :

declare
id number;
begin
declare
name varchar2(100);
descr varchar2(500);
obj_id number;
begin
name:=’minha_tarefa’;
descr:=’Segment Advisor ‘;

dbms_advisor.create_task (
advisor_name => ‘Segment Advisor’,
task_id => id,
task_name => name,
task_desc => descr);

dbms_advisor.create_object (
task_name => name,
object_type => ‘TABLE’,
attr1 => ‘MSIGA’,
attr2 => ‘CT2010’,
attr3 => NULL,
attr4 => NULL,
attr5 => NULL,
object_id => obj_id);

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

dbms_advisor.execute_task(name);
end;
end;

— depois é só vc fazer :

select * from dba_advisor_actions where task_name = ‘minha_tarefa’ ;

Veja as colunas attr1, attr2, attr3, caso o Oracle tenha alguma recomendação, estará nessas colunas.

[]´s