My Oracle Support Banner

Gather Schema Stats Fails With FND_CP_GSM_IPC_AQTBL is Locked (Doc ID 2051321.1)

Last updated on APRIL 07, 2021

Applies to:

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

Symptoms

On Oracle Applications 12.1.3,
when attempting to run Gather Schema Statistics request, the following error occurs:

  In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
  stats on table FND_CP_GSM_IPC_AQTBL is locked
  stats on table FND_SOA_JMS_IN is locked
  stats on table FND_SOA_JMS_OUT is locked


The issue can be reproduced at will with the following steps:
1. Run the Gather Schema Statistics request.

Due to this issue, database administrators cannot collect statistics.

Changes

 

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.