Process appears to be hung in Auto SQL Tuning task


Error :
Tue Jan 20 23:10:31 2015
Process 0x0x6e422dd28 appears to be hung in Auto SQL Tuning task
Current time = 1421781030, process death time = 1421781001
Attempting to kill process 0x0x6e422dd28 with OS pid = 22795
OSD kill succeeded for process 0x6e422dd28

Solution:

The explanation is that the AUTO SQL TUNING TASK has been over-running and as a protective measure it is auto killed. As thus, there is no fix for this and the solution is to disable this job and eventually manually execute it when

needed. Here is how to do that:

To Disable the job:

BEGIN
 DBMS_AUTO_TASK_ADMIN.DISABLE(
 client_name => 'sql tuning advisor',
 operation => NULL,
 window_name => NULL);
 END;
/


To Enable it when needed.

 BEGIN
 DBMS_AUTO_TASK_ADMIN.ENABLE(
 client_name => 'sql tuning advisor',
 operation => NULL,
 window_name => NULL);
 END;
/


Reference:

“How to Avoid or Prevent Hung Auto Tuning Task Messages [ID 1344499.1]”
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: