EBS 12.1.3 , Concurrent Request: Gather Schema Statistics, ERRORS out with ORA-0000: normal, success
We are on EBS 12.1.3, Oracle Database - 11.2.0.3We ran the concurrent Program " Gather Schema Statistics" with following options:
SCHEMA NAME - ALL ESTIMATE % 40 BACKUP FLAG-NOBACKUP HISTORY MODE- LASTRUN
GATHER OPTIONS: GATHER INVALIDATE DEPENDENT CURSON - Y
--------------
Request ERORRS OUT with Following:
**Ends**21-FEB-2013 15:34:27 ORA-0000: normal, successful completion +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ I
n GATHER_SCHEMA_STATS , schema_name= ALL percent= 40 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
stats on table GAT_REQ_QTBL is locked
SCHEMA NAME - ALL ESTIMATE % 40 BACKUP FLAG-NOBACKUP HISTORY MODE- LASTRUN
GATHER OPTIONS: GATHER INVALIDATE DEPENDENT CURSON - Y
--------------
Request ERORRS OUT with Following:
**Ends**21-FEB-2013 15:34:27 ORA-0000: normal, successful completion +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ I
n GATHER_SCHEMA_STATS , schema_name= ALL percent= 40 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
stats on table GAT_REQ_QTBL is locked
Tagged:
1