ORA-16962: SQL statement attempted to begin an autonomous transaction Database version: Oracle 11g Release 2 (11.2) Cause: The SQL statement being analyzed attempted to begin an autonomous transaction, which is not supported. Solution: Analyze another statement or remove the autonomous transaction from the current statement.  Read More →

ORA-16961: SQL statement with SQL patch is ignored Database version: Oracle 11g Release 2 (11.2) Cause: SQL statements with SQL patches are not supported by SQL tuning advisor. Solution: Check the SQL patch information. Rerun SQL repair advisor on that SQL statement for a potential better SQL patch.  Read More →

ORA-16960: SQL Analyze could not reproduce the desired plan. Database version: Oracle 11g Release 2 (11.2) Cause: SQL Analyze failed to reproduce a particular plan using an outline. Solution: Check the outline data.  Read More →

ORA-16959: Statement type has been disabled for SQL Analyze Database version: Oracle 11g Release 2 (11.2) Cause: The system attempted to analyze a type of statement that was disabled by the current feature. Solution: Try a different feature capable of analyzing this statement type.  Read More →

ORA-16958: DML statements running parallel are not supported for test execute. Database version: Oracle 11g Release 2 (11.2) Cause: The specified DML statement cannot be tested for execute because part of it is running parallel. Solution: None  Read More →

ORA-16957: SQL Analyze time limit interrupt Database version: Oracle 11g Release 2 (11.2) Cause: This is an internal error code used indicate that SQL analyze has reached its time limit. Solution: None  Read More →

ORA-16956: Only SELECT or DML statements are supported for test execute. Database version: Oracle 11g Release 2 (11.2) Cause: The specified SQL statement cannot be tested for execute. Solution: None  Read More →

ORA-16955: Unknown error during SQL analyze. Database version: Oracle 11g Release 2 (11.2) Cause: The specified SQL statement failed to be analyzed. Solution: This is an internal error, please contact Oracle support.  Read More →

ORA-16954: SQL parse error. Database version: Oracle 11g Release 2 (11.2) Cause: The specified SQL statement failed to be parsed. Solution: Check if syntax is correct and ensure that this statement can be parsed by the specified user name.  Read More →

ORA-16953: Type of SQL statement not supported. Database version: Oracle 11g Release 2 (11.2) Cause: This type of SQL statement could not be processed. Solution: None  Read More →

ORA-16952: Failed to bind this SQL statement. Database version: Oracle 11g Release 2 (11.2) Cause: Binding this SQL statement failed. Solution: Check if bind variables for that statement are properly specified.  Read More →

ORA-16951: Too many bind variables supplied for this SQL statement. Database version: Oracle 11g Release 2 (11.2) Cause: Binding this SQL statement failed because too many bind variables were supplied. Solution: Pass the correct number of bind variables.  Read More →