Getting ORA-01115 during gather stats (EBS database)
Hi All -
We are getting an ORA-01115 error intermittently when running our gather schema stats job. Here is what I can see from the application-side log:
Current system time is 10-MAR-2021 16:00:22 +---------------------------------------------------------------------------+ [10-MAR-2021 16:00:29]: **Starts** [11-MAR-2021 05:35:14]: **Ends** ORA-0000: normal, successful completion +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ In GATHER_SCHEMA_STATS , schema_name= ALL percent= degree = 8 internal_flag= NOBACKUP stats on table FND_MBL_NOTIFICATION_OUT is locked stats on table WF_NOTIFICATION_OUT is locked stats on table GAT_REQ_QTBL is locked stats on table CCT_QDE_RESP_Q_TBL is locked stats on table WMS_WCS_AQ_QUEUE_TBL is locked Error #1: ERROR: While GATHER_TABLE_STATS: object_name=GL.GL_BALANCES_DELTA***ORA-12801: error signaled in parallel query server P006 ORA-01115: IO error reading block from file (block # )*** +---------------------------------------------------------------------------+ End of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ No completion options were requested. Output file size: 0 Deleting empty output file. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 11-MAR-2021 05:35:15 +---------------------------------------------------------------------------+
0