Home » RDBMS Server » Performance Tuning » Problem in QUICK TUNE advisor
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?
Previous Topic: dbms_stats.gather_schema_stats causes ORA-01555
Next Topic: PEFSTAT dropped and recreated
Goto Forum:
  


Current Time: Tue Dec 06 16:23:37 CST 2016

Total time taken to generate the page: 0.15221 seconds