/* ORACLE Advisor */ :::GRANT GRANT advisor TO USER; :::Get | SergeyGurin

/*
ORACLE
Advisor
*/

:::GRANT
GRANT advisor TO USER;

:::Get the results of an Automatic SQL Tuning task
SELECT DBMS_AUTO_SQLTUNE.report_auto_tuning_task FROM dual;

:::Create tuning task
DECLARE
ret_val VARCHAR2(4000);
BEGIN
ret_val := dbms_sqltune.create_tuning_task( task_name=>'XMKO1', sql_id=>'dc3sxstr12ap8');
dbms_sqltune.execute_tuning_task('XMKO1', execution_params => DBMS_ADVISOR.ARGLIST('time_limit', 60));
END;

:::Report tuning task
SELECT dbms_sqltune.report_tuning_task('XMKO1') FROM dual;

:::Drop tuning task
BEGIN
DBMS_SQLTUNE.DROP_TUNING_TASK('XMKO1');
END;