Database Administration (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center