My Oracle Support Banner

stats on table is locked and unable to purge (FND_STATS_HIST) table. (Doc ID 2828920.1)

Last updated on FEBRUARY 08, 2023

Applies to:

Oracle E-Business Suite Performance - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Gather Schema Statistics is failing with the following errors:

Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 16 internal_flag= NOBACKUP
stats on table WF_NOTIFICATION_OUT is locked
stats on table FND_MBL_NOTIFICATION_OUT is locked
stats on table WMS_WCS_AQ_QUEUE_TBL is locked
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
0

+---------------------------------------------------------------------------+
Concurrent request completed successfully

Error: More than 100,000 rows found in History Table (FND_STATS_HIST). count= 2482793

Changes

 automatic statistics gather is locked and Error: More than 100,000 rows found in History Table (FND_STATS_HIST) example count= 2482793

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.