This discussion is archived
3 Replies Latest reply: Nov 19, 2012 1:47 AM by Mohamed Houri RSS

Imapct of disabling SQL Tuning and Reousrce Manager on oracle 11g r2

Karan Kukreja Journeyer
Currently Being Moderated
Hi All ,

Oracle Database : 11.2.0.2
OS : SPARC 64 Bit

I was looking for an imapct of disabling SQL Tuning and Resource Manager on one of the production databases.

The reason I am planning to do this is that we have observred that the payroll runs gets hanged couple of times due to this .


on googleing i have found out how to do it. Also i have found the same on metalink :
Resource Manager and Sql Tunning Advisory DEFAULT_MAINTENANCE_PLAN [ID 786346.1]

But i am unable to obtain the impact. Please share some doc where i can understand the impact of disabling it.

Regards
KK

Legend

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