This discussion is archived
4 Replies Latest reply: Oct 17, 2012 2:44 AM by kabir RSS

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

User470870-OC Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points