This discussion is archived
12 Replies Latest reply: Nov 11, 2012 5:57 AM by 864103 RSS

performance issue 11g.2

864103 Newbie
Currently Being Moderated
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


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