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:
ORA-600[17092] And ORA-16957 Reported While Running DBMS_SCHEDULER (Doc ID 743873.1)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: