I'm trying to tune query using DBMS_ADVISOR and got the following error.
I have DBA Role
Code:
SQL> BEGIN
2 DBMS_ADVISOR.quick_tune(
3 DBMS_ADVISOR.SQLACCESS_ADVISOR,
4 'my_tune',
5 'SELECT count(*) from sys.dba_hist_sqlstat');
6 END;
7 /
BEGIN
*
ERROR at line 1:
ORA-13600: error encountered in Advisor
QSM-00775: the specified SQL statement cannot be stored in the workload due to invalid table references
ORA-06512: at "SYS.PRVT_ACCESS_ADVISOR", line 1166
ORA-06512: at "SYS.WRI$_ADV_SQLACCESS_ADV", line 164
ORA-06512: at "SYS.PRVT_ADVISOR", line 2318
ORA-06512: at "SYS.DBMS_ADVISOR", line 730
ORA-06512: at line 2
I tried different SQL statements all gives same error.