A problem with a "SYS_AUTO_SQL_TUNING_TASK"
794493Apr 15 2011 — edited Apr 18 2011Hello everybody.
Environment : Oracle 11g R1, OS : Suse Enterprise 10 SP2
5 minutes ago I saw at Grid Control, that my database was reporting a % of wait by concurrency. When I see the top activity was next:
begin dbms_application_info.set_module(:1,:2);
dbms_application_info.set_client_info(:3);
dbms_session.set_identifier (:4);end;
and alert log this lines:
Setting Resource Manager plan SCHEDULER[0x2COD]: DEFAULT_MAINTENANCE_PLAN via scheduler window
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
This SYS ยด session was blocking another one by this problem. So I had to kill it.
Anybody knows about this behavior??
Does somebody help me??
thanks