12 Replies Latest reply: Nov 11, 2012 7:57 AM by 864103 RSS

    performance issue 11g.2

    864103
      hi all ,

      oracle 11g.2 in rac with asm in linux 5

      vender send email :
      With regard to the mediation process we have identified some performance improvements which we feel will speed up the updation of the mediation DB

      i see the alert log in found


      ALTER SYSTEM SET job_queue_processes=1000 SCOPE=BOTH SID='*';


      i read in this parameter this will be allow 1000 job to run in corcurrent
      so this will be decrease the permormance ???right??correct me if i am wrong