Gather Schema Statistics Does NOT Skip Tables Added TO FND_EXCLUDE_TABLE_S
(Doc ID 2656141.1)
Last updated on APRIL 08, 2020
Applies to:Oracle Concurrent Processing - Version 12.2 and later
Information in this document applies to any platform.
Exclude Tables From the Gather Schema Statistics Current Program using below
1. Retrieve the Application ID by running any of the SELECT statements.
Select application_id From fnd_tables Where table_name in ('XXXX');
2. Run the following script once for each external table to insert a record corresponding to it in FND_EXCLUDE_TABLE_STATS:
fnd_stats.load_xclud_tab('INSERT',<Application_ID from step 1>,'XXXX');
3. Check FND_EXCLUDE_TABLE_STATS table has entry of XXXX.
After that run Gather Schema Statistics(GSS) with GATHER AUTO option, Gather stats is still being run on this table.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document