ORA-13602: The specified parameter RECOMMEND ALL is not valid for task or object Advisor.

Cause:

Make sure you give the right parameter in the advisor procedure

SQL> BEGIN
  2  dbms_advisor.set_task_parameter(
  3  task_name => 'Advisor',
  4  parameter => 'RECOMMEND ALL', <----- _underscore missed
  5  value => 'TRUE');
  6  END;
  7  /
BEGIN
*
ERROR at line 1:
ORA-13602: The specified parameter RECOMMEND ALL is not valid for task or
object Advisor.
ORA-06512: at "SYS.PRVT_ADVISOR", line 5010
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.PRVT_ADVISOR", line 1248
ORA-06512: at "SYS.PRVT_ADVISOR", line 4902
ORA-06512: at "SYS.DBMS_ADVISOR", line 401
ORA-06512: at line 2

Solution:

Check if you give correct parameter in set task parameter

This parameter stores various attributes that affect workload collection, tuning decisions and reporting.

SQL> BEGIN
  2  dbms_advisor.set_task_parameter(
  3  task_name => 'Advisor',
  4  parameter => 'RECOMMEND_ALL',
  5  value => 'TRUE');
  6  END;
  7  /

PL/SQL procedure successfully completed.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s