DBMS_ADVISOR ORA-13699 [message #481335] |
Tue, 02 November 2010 09:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
If I create a quick tuning task for the access advisor, I cannot get the report out:
orcl> exec dbms_advisor.quick_tune(dbms_advisor.sqlaccess_advisor,'quick','select count(n) from t3 where n=20');
PL/SQL procedure successfully completed.
orcl> select dbms_advisor.get_task_report('quick') from dual;
ERROR:
ORA-13699: Advisor feature is not currently implemented.
ORA-06512: at "SYS.PRVT_ADVISOR", line 3147
ORA-06512: at "SYS.DBMS_ADVISOR", line 590
ORA-06512: at line 1
no rows selected
orcl> Am I missing something? There is nothing relevant in Metalink. It isn't a new feature.
|
|
|
|
Re: DBMS_ADVISOR ORA-13699 [message #481343 is a reply to message #481337] |
Tue, 02 November 2010 11:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Thank you for looking at this, but it doesn't get me any further:jw> create table item as select * from all_users;
Table created.
jw> VARIABLE task_name VARCHAR2(255);
jw> VARIABLE sql_stmt VARCHAR2(4000);
jw> exec :sql_stmt := 'select count(*) from item'
PL/SQL procedure successfully completed.
jw>
jw> exec:task_name := 'MY_QUICKTUNE_TASK';
PL/SQL procedure successfully completed.
jw> exec DBMS_advisor.quick_tune (dbms_advisor.sqlaccess_advisor, :task_name, :sql_stmt);
PL/SQL procedure successfully completed.
jw>
jw> select dbms_advisor.get_task_report('MY_QUICKTUNE_TASK') from dual;
ERROR:
ORA-13699: Advisor feature is not currently implemented.
ORA-06512: at "SYS.PRVT_ADVISOR", line 3147
ORA-06512: at "SYS.DBMS_ADVISOR", line 590
ORA-06512: at line 1
no rows selected
jw> variable rep varchar2(4000);
jw> exec :rep:=dbms_advisor.get_task_report('MY_QUICKTUNE_TASK');
BEGIN :rep:=dbms_advisor.get_task_report('MY_QUICKTUNE_TASK'); END;
*
ERROR at line 1:
ORA-13699: Advisor feature is not currently implemented.
ORA-06512: at "SYS.PRVT_ADVISOR", line 3147
ORA-06512: at "SYS.DBMS_ADVISOR", line 590
ORA-06512: at line 1
jw>
|
|
|
|
Re: DBMS_ADVISOR ORA-13699 [message #481376 is a reply to message #481344] |
Tue, 02 November 2010 14:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
dbms_advisor.get_task_report definitely exists! And is documented (even back in 10g), it just doesn't seem to report anything following dbms_advisor.quick_tune. At least, not for me. How are you getting your reports out? dbms_advisor.quick_tune doesn't seem to populate dba_advisor_recommendations, and dbms_advisor.get_task_script doesn't give me anything either.
|
|
|