3 Replies Latest reply: Nov 19, 2012 3:47 AM by Mohamed Houri RSS

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

    Karan Kukreja
      Hi All ,

      Oracle Database :
      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.