trigger gather stats for a single table in oracle apps R12
gather stats for a single table in oracle apps R12
connect to apps user and trigger below query
begin
FND_STATS.GATHER_TABLE_STATS(ownname=>'&owner',
tabname =>'&table_name',
percent=> 80,
degree=> 80,
cascade=>TRUE,
granularity=>'ALL');
end;
/
Comments
Post a Comment