dbms_stats.gather_table_stats is used to analyze a single table.
begin
DBMS_STATS.GATHER_TABLE_STATS(ownname => ‘PROD’, tabname =>’&name’, ESTIMATE_PERCENT => 100,METHOD_OPT => ‘FOR ALL COLUMNS SIZE AUTO’, CASCADE => TRUE,DEGREE => 5);
end;
/
Run the gather statistics for a Oracle table
