Database Administration (MOSC)

MOSC Banner

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

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center