Yesterday, I had to run FND_STATS.gather_schema_stats for XX schema, manually. Because, it was not registered with Oracle Apps.
Upon querying the last_analyzed column of dba_tables, I found some of the tables from XX schema are not analyzed and they are temporary tables (temporary column=Y).
Finding:
FND_STATS don't analyze temp tables.
No comments:
Post a Comment
Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)