SQL> select
2 DBMS_SQLTUNE.REPORT_TUNING_TASK(
3 task_name=>'ADDM:4133494086_2_47099',
4 type => 'TEXT',
5 "LEVEL" => 'TYPICAL',
6 section => 'ALL',
7 object_id => 7,
8 result_limit => NULL,
9 owner_name => 'SYS',
10 execution_name=>'EXEC_927514')
11 from dual;
Error starting at line : 1 in command -
select
DBMS_SQLTUNE.REPORT_TUNING_TASK(
task_name=>'ADDM:4133494086_2_47099',
type => 'TEXT',
"LEVEL" => 'TYPICAL',
section => 'ALL',
object_id => 7,
result_limit => NULL,
owner_name => 'SYS',
execution_name=>'EXEC_927514')
from dual
Error report -
ORA-13785: missing target object for tuning task "ADDM:4133494086_2_47099"
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 8740
ORA-06512: at "SYS.DBMS_SQLTUNE", line 1052
ORA-06512: at line 1
Getting ORA-13785 while retrieving SQL advisor findings using DBMS_SQLTUNE.REPORT_TUNING_TASK
Please suggest