delcare
vSQL VARCHAR2(1000);
BEGIN
FOR rec IN (SELECT table_name,owner FROM houfulin.hfl_mid_zc )
LOOP
BEGIN
vsql:='BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME=>'''||rec.owner||''',TABNAME=>'''||rec.table_name||''',method_opt=>''FOR ALL COLUMNS SIZE 1'', estimate_percent=>25, degree=>''8'', granularity=>''all'', no_invalidate=>false, cascade=>true ); end;
EXECUTE IMMEDIATE vSQL;
COMMIT;
EXCEPTION WHEN OTHERS THEN
NULL;
END;
END LOOP;
COMMIT;
end