ORA-13639: The CURRENT operation was interrupted because it timed OUT
該錯誤是由於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;
/
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;
/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-2132270/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- sqlnet.log error - Operation timed outSQLError
- eclipse 線上安裝android包:Download interrupted: Read timed outEclipseAndroid
- 解決 connect to host github.com port 22 operation timed outGithub
- adstrtal.sh報超時錯誤 ERROR : Timed out( 100000 ): Interrupted ExceptionErrorException
- svn“Previous operation has not finished; run 'cleanup' if it was interrupted
- open-falcon ---安裝Dashboard時候報錯"SSLError: The read operation timed out"Error
- Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed outError
- “Operation is not valid due to the current state of the object.”Object
- Fatal NI connect error 12170 TNS-12535/TNS-00505 TNS:operation timed outError
- [Clickhouse] Clickhouse 報SQLException : Read timed outSQLException
- svn“Previous operation has not finished; run ‘cleanup‘ if it was interrupted“報錯的解決方法
- oracle 11.2.0.3 grid ons 程式 checked timed outOracle
- 【Oracle】 inbound connection timed out (ORA-3136)Oracle
- pip安裝selenium報錯:Read timed out
- Android-問題-obtainBuffer timed out (is the CPU pegged?)AndroidAI
- 報錯(已解決)Command timed out after no timeout
- java.sql.SQLException:IO 錯誤:Socket read timed out !JavaSQLException
- idea使用svn “Previous operation has not finished; run 'cleanup' if it was interrupted“報錯的解決方法Idea
- 執行systemctl status ssh返回“Failed to get properties: Connection timed out”AI
- 【解決】io.lettuce.core.RedisCommandTimeoutException: Command timed outRedisException
- oracle11gR2 Timed out waiting for the CRS stack to startOracleAI
- java.sql.SQLRecoverableException: IO Error: Socket read timed out 排查歷程JavaSQLExceptionError
- oozie.action.hadoop.LauncherException: IO error Connection timed out: no further informationHadoopExceptionErrorORM
- java.net.SocketTimeoutException: Read timed out異常解決方法JavaException
- WARNING: inbound connection timed out (ORA-3136)錯誤分析
- ORA-3136錯誤分析——WARNING Inbound Connection Timed Out
- io.lettuce.core.RedisCommandTimeoutException: Command timed out 解決辦法RedisException
- jdbc訪問KingbaseES資料庫SocketTimeoutException Read timed outJDBC資料庫Exception
- Feign,HTTP連線超時問題SocketTimeoutException: Read timed outHTTPException
- kernel: ide-cd: cmd 0x1e timed out -- LinuxIDELinux
- 資料庫日誌中出現啟動JOB程式的TIMED OUT資訊資料庫
- RetryableException: Read timed out executing導致服務假死無響應Exception
- Failed to connect to ESP8266: Timed out waiting for packet headerAIHeader
- Detailed Item Cost Report (XML) timed out waiting for the Output Post-processor to finishAIXML
- Loadrunner 伺服器壓力上不去,客戶端出現大量timed out伺服器客戶端
- CM agent 傳送heartbeat給CM server 不斷髮生 connection refused:timed outServer
- WARNING: inbound connection timed out (ORA-3136)連線超時問題
- 【python】pip安裝庫時出現Read timed out.解決辦法Python