Use fnd_stats to gather stats of a table in oracle applications 11i/R12.
connect as apps user and run below statement.
FND_STATS.GATHER_TABLE_STATS(ownname=>'&owner',
tabname =>'&table_name',
percent=> 80,
degree=> 80,
cascade=>TRUE,
granularity=>'ALL');
end;
/
tabname =>'&table_name',
percent=> 80,
degree=> 80,
cascade=>TRUE,
granularity=>'ALL');
end;
/
No comments:
Post a Comment