output of tuning task fails getting recommendation script DBMS_ADVISOR.get_task_script
11.2.0.3 on sparc64
I've populated an SQL tuning Set ok, ran the task below without error.
I'm getting this when trying to get the Recommendation script.
SQL> SET LONG 100000 PAGESIZE 50000
SQL> SELECT DBMS_ADVISOR.get_task_script('SQLACCESS1') AS script
2 FROM dual;
SET PAGESIZE 24
ERROR:
ORA-21779: duration not active
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.PRVT_ADVISOR", line 3350
ORA-06512: at "SYS.DBMS_ADVISOR", line 641
ORA-06512: at line 1
no rows selected
I also tried
EXECUTE DBMS_ADVISOR.CREATE_FILE(DBMS_ADVISOR.GET_TASK_SCRIPT(task_name => 'SQLACCESS1', type => 'IMPLEMENTATION'), 'tune', 'script.sql');