ORA-13663: The task SYSAUTOSQLTUNINGTASK contains no results for execution (Doc ID 1364523.1) Last updated on FEBRUARY 14, 2019. Applies to: Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.3 Release 10.2 to 11.2. SYSAUTOSQLTUNINGTASK is the default name of the Automatic SQL Tuning task. You can use this query DBAADVISORLOG to check the execution time of the same. You can also use Enterprise Manager to manage the features regarding Automatic SQL Tuning.
Sys_auto_sql_tuning_task
Oracle 12c offers a useful utility called the SQL Tuning Advisor. You can use this built-in tool to provide suggestions or recommendations about certain SQL statements. Although it may not always give perfect advice, just like anything else, having it in your toolbox of tuning techniques is beneficial.
Now that you’ve added the index, a few things are evident:
Sys_auto_sql_tuning_task Disable
Often one of the tough parts about tuning a database is having a solid understanding of the application and the data. The issue might not always be obvious. Sometimes engaging other application and data experts helps.
Explain to them your findings and what you propose. They may be able to help you come to a conclusion. Also, if the data is part of a packaged third-party application, sometimes opening a ticket with the vendor is the way to go.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |