SQL Performance (MOSC)

MOSC Banner

output of tuning task fails getting recommendation script DBMS_ADVISOR.get_task_script

edited Dec 15, 2015 10:09AM in SQL Performance (MOSC) 4 commentsAnswered

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');

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