Thursday, 8 September 2022

How to check Stale statistics of Table

 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>

No comments:

Post a Comment