FND_STATS don't consider temp tables

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.
at

No comments:

Post a Comment

Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)

Subscribe to: Post Comments (Atom)

  Find below few useful scripts for  Performance  Management:: # Important MOS notes for TRACING: There are several ways to trace a particul...

  • adapcctl.sh: exiting with status 204
    On a new VIS R12.1 installation, the OHS (oracle http server) failed to start and give status 204. Upon querying the status of opmn manage...
  • Ever Hit with ORA-46981 in Oracle EBS Environment ?
    Recently when I was tasked to do a cloning of my production Oracle Apps instance to a target single-node server,  I hit a dead-end with the ...
  • (no title)
    A nice story about RMAN.           The story begins,  when one of my associate DBAs did an RMAN restoration & recovery 2 days back...