After Upgrade to 19.3, SQL Tuning Advisor Raises Errors 'Invalid fix_control Setting 26664361:7 Found in Hint: sql_id' in Alert Log
(Doc ID 2690382.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later Information in this document applies to any platform.
Symptoms
After upgrade from Oracle Database 12.1.0.2 to 19.3.0.0, error in alert.log:
Setting Resource Manager plan SCHEDULER[0x4444]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Invalid fix_control setting 26664361:7 found in hint: sql_id=xxxxxxxxxxx Invalid fix_control setting 20243268:1 found in hint: sql_id=xxxxxxxxxxx End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Changes
Database upgraded to Oracle Database Version 12.2 or higher.
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
