5 Replies Latest reply on Apr 6, 2013 8:10 AM by Marwim

    getting  error

    surendra4y
      Hi ,

      When i am excuting below block getting error.
      Below are the desc.

      DECLARE
      l_sql_tune_task_id VARCHAR2(100);
      BEGIN
      l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
      begin_snap => 386,
      end_snap => 416,
      sql_id => '8m99mxqnwkyqs',
      scope => DBMS_SQLTUNE.scope_comprehensive,
      time_limit => 60,
      task_name => '19v5guvsgcd1v_AWR_tuning_task',
      description => 'Tuning task for statement 19v5guvsgcd1v in AWR.');
      DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);
      END;
      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 236
      ORA-06512: at "SYS.DBMS_SQLTUNE", line 542
      ORA-06512: at line 4

      Script Terminated on line 1.

      Edited by: surendra4y on Apr 5, 2013 11:36 PM