My Oracle Support Banner

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.

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

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
Symptoms
Changes
Cause
Solution
References


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