Leave a Comment:
1 comments
Good Catch, leme add my piece:
When we submit Gather Schema Stats with Parameter ALL, concurrent request will complete successfully, and DBAs will not realize that custom schemas are not analyzed.
select count(table_name) from dba_tables where last_analyzed is not null and owner=
Here you realize none of the tables in custom schema are analyzed.
Refer to the Oracle Alerts documentation (page 7-27) on how to register the custom product installation.
The URL to the Alerts documentation is
http://download-west.oracle.com/docs/cd/B25516_08/current/acrobat/115alrug.pdf
Refer Note:394555.1
FND_STATS concurrent program does not PICK UP seemingly properly REGISTERED CUSTOM SCHEMAS