gather stats的小程序

create or replace procedure get_table_history_stats

is

begin

dbms_stats.gather_schema_stats(ownname=>'HISSAAS');

insert into table_history_stats

select table_name,num_rows,BLOCKS,empty_blocks,AVG_SPACE,avg_row_len,

to_date(to_char(sysdate,'yyyy/mm/dd'),'yyyy/mm/dd')

from user_tables where num_rows<>0;

commit;

end get_table_history_stats;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1059613/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1059613/