ORA-7445:[qksfmKillTest]


Okay.. this one was a killer...  Shivers down the spine when i saw this first in the alert log. Data corruption or segment corruption ? no clue. Checked on metalink , no direct info.. so first things first , whenever you get this error ( or ORA-0600) raise a SEV1 SR. Oracle can tell you the best what to do in these cases. 

So i raised a SEV 1 SR with Oracle. Oracle guys asked for the alert log and the trace files generated. They scanned it and told me that it was an issue with an automatic tuning task and this can be safely ignored. its not a corruption issue. 

Something had killed the automatic tuning task. Oracle suggested to safely ignore this error for the time being and watch if it occurs again. 

They also suggested if i wish to cancel the sql tuning advisor , but since we have been using it often we decided not to. However , it can be disabled by using the query below :

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

/


Cheers
Orafolks:)