暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-13639: The C operation was interrupted because it timed OUT

DBA小记 2021-08-06
2624

    alert日志报错信息:

    Errors in file u01/app/oracle/diag/rdbms/wlpub/wlpub1/trace/wlpub1_j001_215130.trc:
    ORA-13639: The current operation was interrupted because it timed out.
    End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
    复制

        该错误是由于SQL Tune Job执行超时导致,默认“Time Limit"是3600秒,即一个小时。

      DECLARE 
      l_sql_tune_task_id CLOB;
      BEGIN
      l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
      begin_snap =>,
      end_snap =>,
      sql_id => '',
      scope => DBMS_SQLTUNE.scope_comprehensive,
      time_limit =>3600,
      task_name => '',
      description => 'Tuning task for statement SYS_AUTO_SQL_TUNING_TASK in AWR.');
      DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);
      END;
      /
      复制

      可以看到这里time_limit设置成了3600秒,可通过以下方式修改:

        BEGIN
        DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETER(task_name => ' SYS_AUTO_SQL_TUNING_TASK ', parameter => 'TIME_LIMIT', value => 7200);
        END;
        /
        复制


        文章转载自DBA小记,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

        评论