Process 0x0x... appears to be hung in Auto SQL Tuning task
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
oracle linux 7.9
database with only 1 pdb.
i uisng OEM 13.4
Hi, i have an errors in the log.xml file:
/u01/app/oracle/diag/rdbms/database/database/alert/log.xml
this is the error sequence in log.xml:
type='ERROR' group='SQL_Tune'
Process 0x0xc43b8830 appears to be hung in Auto SQL Tuning task
Current time = 1688898962, process death time = 1688898945
Attempting to kill process 0x0xc43b8830 with OS pid = 31966
OSD kill succeeded for process 0xc43b8830
As far as I understand, the "auto sql tuning task" takes too long and cannot be executed, so that process is automatically killed? why is this happening and what is the solution? I tried increasing the execution time to 3600 but still the problem occurs. I have currently disabled the auto sql tuning task. but how can i find what is the cause of the problem and how to solve it?