3 Replies Latest reply: Sep 13, 2013 1:41 AM by Billy~Verreynne RSS

    Enforcing Node Affinity for PL/SQL Packages???


      Dear fellow dbas,


      we have a random performance problem on one of our 11gR1 RAC databases due to io waits.

      In fact, we tracked down the problem and noticed that sql packages are executed on node 1 causing bad times and were executed on node 2 with good results.

      Now the question is how can we enforce these pl/sql packages, which are called via external batch jobs, to be executed on node 2?

      Instance affinity came to my mind but I have no clue whatsoever how to apply it for packages and embedded pl/sql code.


      Can you please give me an advice?


      Thanks for your feedback!


      Best regards,