Oracle Database Errors or Warnings from Error ORA-13789 to ORA-13799


ORA-13789: invalid process action
Cause: The user passed an invalid action to process a SQL statement. Possible value is any subset of a comma-seperated list of EXECUTE and EXPLAIN_PLAN.
Action: Check the action argument and retry the operation.
ORA-13790: invalid value for time limit
Cause: The user passed an invalid value for the time limit argument.
Action: Check the argument specified value and retry the operation.
ORA-13791: cannot resume a task created to process a single statement
Cause: An attempt was made to resume a task that was created for a single SQL statement. A task can be resumed only if it is used for a SQL Tuning Set.
Action: No action required.

ORA-13793: invalid comparison metric
Cause: An invalid metric to compare SQL performance was specified.
Action: s.
ORA-13794: execution type mismatch
Cause: An attempt was made to analyze the performance of a SQL workload using two executions that were generated using two different
Action: check the name and type of task executions to analyze and retry the operation.
ORA-13795: missing task execution
Cause: An insufficient number of valid task executions to analyze the performance of a SQL workload were specified.
Action: run the task to generate two executions of the same type and retry the operation.

ORA-13796: invalid value string specified for problem type
Cause: An invalid problem type was specified to the SQL diagnosis advisor. Problem type should be one of the PROBLEM_TYPE_* defined in ‘admin/dbmsdiag.sql’.
Action: Specify valid problem type.
ORA-13797: invalid SQL Id specified, string
Cause: Invalid SQL Id specified for conversion.
Action: Specify valid SQL Id.
ORA-13798: Parameter string cannot be NULL.
Cause: A call to GET_THRESHOLD procedure was made without a required parameter.
Action: Specify a valid value for this parameter.
ORA-13799: threshold not found
Cause: No threshold was found with the specified threshold key.
Action: No action required.

Above are list of Oracle Database Errors or Warnings from Error ORA-13789 to ORA-13799 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *