4 Replies Latest reply: Oct 17, 2012 4:44 AM by kabir RSS

    Error in production database alert log file and instance will slow down.

    User470870-OC
      Hello Everyone,

      Database version : 11.1.0.7.0
      Applications : R12.1.3
      OS : RHEL 5.5

      We are getting an error message in the alertlog file and instance will slow down for about 30 mins.
      It is happening since long but we noticed this error in the aler log recently.
      What is this error messgae about and is it causing the slowness with the instance.?
      Please assist ...

      Setting Resource Manager plan SCHEDULER[0x72F78]:DEFAULT_MAINTENANCE_PLAN via scheduler window
      Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
      Wed Oct 03 10:30:04 2012
      Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
      Wed Oct 03 10:32:16 2012
      End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
      Wed Oct 03 10:45:14 2012


      Thanks in advance