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

    Enforcing Node Affinity for PL/SQL Packages???

    skahlert

      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,

       

      Sebastian