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)

 SPACE MANAGEMENT :: 1. Table space usuage: ============== SELECT tablespaces.tablespace_name,          allocated.total_alloc allocated_mb, ...

  • 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...
  • FRM-92102 Network error on forms client in AS10g
    Recently, I got a complaint from my AS10g users, that they are facing frequent disconnection with the server. May be due to network distrupt...
  • (no title)
    A nice story about RMAN.           The story begins,  when one of my associate DBAs did an RMAN restoration & recovery 2 days back...