6 Replies Latest reply on Sep 2, 2019 1:24 PM by Beauty_and_dBest

    EBS 12.1.3 Gather Schema Stats

    Beauty_and_dBest

      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