hung in Auto SQL Tuning task, critical alert in GC
Critical alert comes as:
mydb01 : -K- mydb1:Operational error () detected in /u01/app/oracle/diag/rdbms/mydb/mydb/alert/log.xml at time/line number: Tue Apr 20 00:10:51 2010/36623. : 00:15 20/04/10
I had opened an SR and the result is: It is a bug.
Bug 8636312: HUNG IN AUTO SQL TUNING TASK which is based on the Oracle base bug Billy gave above.
No workaround is provided, and the bug is not patched or solved in newer version.
Acknowledging this alert from the GC, solved my need of stopping the anoyingly coming of this alert.
You can acknowledge the alert by clicking the alert link, which brings details of it, containing “acknowlege” button.
This alert is related with the Metric: “Generic Operational Error”
Meantime you can drop auto sql tuning job as follows:
Check the AUTO SQL TUNING TASK exist:
SELECT TASK_NAME, STATUS FROM DBA_ADVISOR_TASKS
WHERE task_name LIKE ‘%SYS_AUTO_SQL_TUNING_TASK%';
Drop it with command:
Waiting for the patch.