ORA-16957: SQL Analyze time limit interrupt

Cause:
The ORA-16957 error is an internal error code used to indicate that SQL analyze has reached its time limit.

Action:
According to MOS Doc ID 1275248.1  , 
(This is an unpublished bug. The bug is fixes in version 12.1)
The error ORA-16957: SQL Analyze time limit interrupt, can be ignored safely, as it does not indicate any problems with the database.

If the error ORA-16957: SQL Analyze time limit interrupt comes along with
ORA-00600: internal error code, arguments: [17092], [16957], [], [], [], [], [], []
you cannot simply ignore it, you have to  read the below MOS note and apply recommended patches:

1 comment:

  1. if this is a bug it is not fixed in 11.2.0.2 still

    ReplyDelete