Sql Tuning Advisor Errors with 'ORA-01403: no data found'
(Doc ID 2520211.1)
Last updated on NOVEMBER 06, 2019
Oracle Database - Enterprise Edition - Version 220.127.116.11 and later Information in this document applies to any platform.
Sql tuning advisor errors out everynight with following errors:
sql tuning advisor FRIDAY_WINDOW FAILED ORA-01403: no data found ORA-06512: at "SYS.PRVT_ADVISOR", line 3333 ORA-06512: at "SYS.PRVT_ADVISOR", line 6762 ORA-06512: at "SYS.PRVT_ADVISOR", line 3035 ORA-06512: at "SYS.DBMS_ADVISOR", line 262 ORA-06512: at "SYS.DBMS_SQLTUNE", line 1186 ORA-06512: at line 19
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!