Database Tuning (MOSC)

MOSC Banner

Failed to set time_limit

Hi,

SELECT parameter_name, parameter_value

FROM  dba_advisor_parameters

WHERE task_name = 'SYS_AUTO_SQL_TUNING_TASK'

 4 AND  instr(parameter_name, 'TIME_LIMIT') >0;


PARAMETER_NAME

--------------------------------------------------------------------------------

PARAMETER_VALUE

--------------------------------------------------------------------------------

TIME_LIMIT

3600


LOCAL_TIME_LIMIT

3600


BEGIN

 DBMS_AUTO_TASK_ADMIN.DISABLE(

 client_name => 'sql tuning advisor',

 operation => NULL,

 window_name => NULL);

END;

/


BEGIN

 DBMS_SQLTUNE.set_tuning_task_parameter('SYS_AUTO_SQL_TUNING_TASK', 'TIME_LIMIT', 10800);

END;

/


BEGIN

 DBMS_SQLTUNE.set_tuning_task_parameter('SYS_AUTO_SQL_TUNING_TASK', 'TIME_LIMIT', 7200);

END;

/



BEGIN

 DBMS_AUTO_TASK_ADMIN.ENABLE(

 client_name => 'sql tuning advisor',

 operation => NULL,

 window_name => NULL);

END;

/


PL/SQL procedure successfully completed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center