Sql Tuning Advisor With Error 'ORA-13780: SQL statement does not exist' When Granted "x" User With All The Privileges (Doc ID 2411398.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

• Sql Tuning Advisor errors with following message:
  SQL> DECLARE
  l_sql_tune_task_id VARCHAR2(100);
  BEGIN
  l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
  sql_id => '0rw408k48x9vy',
  scope => DBMS_SQLTUNE.scope_comprehensive,
  time_limit => 500,
  task_name => '0rw40x9vy_tuning',
  description => 'Tuning task1 for statement 0rw408k48x9vy',
  con_name => 'CBMSSTG');
  DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);
  END;
  / 2 3 4 5 6 7 8 9 10 11 12 13
  DECLARE
  *
  ERROR at line 1:
  ORA-13780: SQL statement does not exist.
  ORA-06512: at "SYS.
   

Cause