SQL>select owner,table_name from dba_tab_statistics
where stale_stats='YES'and object_type='TABLE'
OWNER TABLE_NAME
APPLSYS FND_CONCURRENT_PROCESSES
APPLSYS FND_CONCURRENT_QUEUES
APPLSYS FND_NODES
APPLSYS FND_CONFLICTS_DOMAIN
APPLSYS FND_TEMP_FILES
5 rows selected.
SQL>
APPLSYS FND_CONCURRENT_QUEUES
APPLSYS FND_NODES
APPLSYS FND_CONFLICTS_DOMAIN
APPLSYS FND_TEMP_FILES
5 rows selected.
SQL>
No comments:
Post a Comment