ORA-13780: SQL statement does not exist. ORA-06512: at “SYS.DBMS_SYS_ERROR”

Error:
====

When we run the sql_tuning_task we are
getting the below error in the database.


SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
2 L_SQL_TUNE_TASK_ID VARCHAR2(100);
3 BEGIN
4 L_SQL_TUNE_TASK_ID :=
DBMS_SQLTUNE.CREATE_TUNING_TASK (
5 SQL_ID => ‘fcs0af97qvuft’,
6 SCOPE =>
DBMS_SQLTUNE.SCOPE_COMPREHENSIVE,
7 TIME_LIMIT => 600,
8 TASK_NAME => ‘fcs0af97qvuft_task’,
9 DESCRIPTION => ‘Tuning task for
fcs0af97qvuft’);
10 DBMS_OUTPUT.PUT_LINE(‘l_sql_tune_task_id:
‘ || L_SQL_TUNE_TASK_ID);
11 END;
12 /
DECLARE
*
ERROR AT LINE 1:
ORA-13780: SQL statement does not exist.
ORA-06512: at
“SYS.DBMS_SYS_ERROR”, line 79
ORA-06512: at
“SYS.PRVT_SQLADV_INFRA”, line 125
ORA-06512: at “SYS.DBMS_SQLTUNE”,
line 655
ORA-06512: at line 4


Solution:
========


1. The sql_id is not exist on the server.

2.If I specify in the task 2 snapshots that
include an execution of the particular SQL statement, I get no error:
  • July 11, 2017 | 32 views
  • Comments