Skip to main content

Oracle analyzing index status

begin
  for i in (select index_name from user_indexes) loop
     execute immediate 'analyze index '||i.index_name||' validate structure';
     insert into indstat select * from index_stats;
  end loop;
  commit;
end;

Comments

Popular posts from this blog

Find and replace with sed command in Linux

Find and replace feature is always handy. It can turn into a torture when it comes to change or delete a simple constant string in a text file. There is a handy tool in linux for doing these kind of tihngs. Actually sed is not a text editor but it is used outside of the text file to make changes.