重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-16957: "SQL Analyze time limit interrupt" Errors [打印本页]

作者: 刘泽宇    时间: 2022-7-22 16:01
标题: ORA-16957: "SQL Analyze time limit interrupt" Errors
SYMPTOMS
The following error is reported in the alert.log:
ORA-16957: SQL Analyze time limit interrupt
  
CAUSE
The ORA-16957 error is an internal error code used to indicate that SQL Tuning Task has reached the time limit for tuning a specific sql.
The default time limit is 3600 seconds.

SOLUTION
1. Check the current values for the time limit related parameters:
COLUMN parameter_value FORMAT A30
SELECT parameter_name, parameter_value
FROM dba_advisor_parameters
WHERE task_name = 'SYS_AUTO_SQL_TUNING_TASK'
AND parameter_name IN ('TIME_LIMIT',
'DEFAULT_EXECUTION_TYPE',
'LOCAL_TIME_LIMIT');


Then, increase the time:

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

   
Or

-- This procedure updates the value of a SQL tuning parameter of type VARCHAR2 or NUMBER as used for the reserved auto tuning task, SYS_AUTO_SQL_TUNING_TASK.
BEGIN
  DBMS_AUTO_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER(parameter => 'TIME_LIMIT', value => 7200);
END;
/


2. ORA-16957 may appear in the alert.log together with other error messages or alone:






欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2