EBS 12.1.3
11g
OL6
Hi ALL,
Our scheduled program grather schema stats has always error on locked statistics.
Is this okay? Or can I disregard it?
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDGSCST module: Gather Schema Statistics
+---------------------------------------------------------------------------+
Current system time is 31-AUG-2019 12:30:36
+---------------------------------------------------------------------------+
**Starts**31-AUG-2019 12:30:37
**Ends**31-AUG-2019 15:32:29
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table AQ$_WF_CONTROL_P is locked
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table FND_CP_GSM_OPP_AQTBL is locked
stats on table FND_SOA_JMS_IN is locked
stats on table FND_SOA_JMS_OUT is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.REGION_LOCATIONS_TST***ORA-20000: index "MSC"."REGION_LOCATIONS_N1_TST" or partition of such index is in unusable state***
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDGSCST with request ID 14953424 to start at 07-SEP-2019 12:30:00 (ROUTINE=AFPSRS)
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
0
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 31-AUG-2019 15:32:29
+---------------------------------------------------------------------------+
Kind regards,
jc