OraFAQ Forum: Performance Tuning » Problem in QUICK TUNE advisor

Home » RDBMS Server » Performance Tuning » Problem in QUICK TUNE advisor

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in QUICK TUNE advisor [message #243106]

Wed, 06 June 2007 02:00

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

begin
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,'my task','select * from sadat.test');
end;

This code give these errors:
ORA-13600: error encountered in Advisor
QSM-00784: the table SH.% referenced in the list SH.% is invalid for parameter
VALID_TABLE_LIST
ORA-06512: at "SYS.PRVT_ACCESS_ADVISOR", line 1501
ORA-06512: at "SYS.WRI$_ADV_SQLACCESS_ADV", line 176
ORA-06512: at "SYS.PRVT_ADVISOR", line 2594
ORA-06512: at "SYS.DBMS_ADVISOR", line 726

can anyone help me?

Report message to a moderator

Previous Topic:	dbms_stats.gather_schema_stats causes ORA-01555
Next Topic:	PEFSTAT dropped and recreated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 17:23:27 CST 2024