Thursday 18 August 2011

update statistics for all objects in one paticular schema into oracle 10 G

Exec dbms_stats.gather_schema_stats(ownname=>'schemaname',cascade=>true,options=>'gather',degree=>4);

No comments:

Post a Comment