Gather Schema Statistics Does NOT Skip Tables Added TO FND_EXCLUDE_TABLE_S (Doc ID 2656141.1)

Last updated on MARCH 30, 2023

Applies to:

Symptoms

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:

Begin
fnd_stats.load_xclud_tab('INSERT',<Application_ID from step 1>,'XXXX');
End;

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.

Changes

 N/A

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.