My Oracle Support Banner

Gather Schema Statistics failed with "ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired" (Doc ID 2851798.1)

Last updated on MARCH 02, 2022

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Executing "Gather Schema Statistics" failed with below error. This program has been running fine without error until yesterday.
Tried restarting both AP and DB Tiers since the error message seems to be related to "resource busy", but error still occurs after restarting.

ERROR

FNDGSCST: Gather Schema Statistics
+---------------------------------------------------------------------------+

Current system time is 23-FEB-2022 01:00:22

+---------------------------------------------------------------------------+

[23-FEB-2022 01:00:22]: **Starts**
[23-FEB-2022 01:02:14]: **Ends**
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ZX percent= 10 degree = 1 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_ACCOUNTS***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_ACCOUNT_RATES***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_ACCT_TX_CLS_DEFS_ALL***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***
...
...
Error #17: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_DET_FACTORS_TL***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***
Error #18: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_DET_FACTOR_TEMPL_B***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***
Error #19: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_DET_FACTOR_TEMPL_DTL***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***
Error #20: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_DET_FACTOR_TEMPL_TL***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***
Error #21: ERROR: While GATHER_TABLE_STATS:
object_name=ZX.ZX_EVENT_CLASSES_B***ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired***

 




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
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.