job_queue_processes in 11g

  • From: C P <carlospena999@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 29 May 2014 14:35:12 -0500

List

I saw a 11.2 production DB with a job_queue_processes setting at 1000. Is
that derived as cpu_count*parallel_threads_percpu. our cpu count is 10.  Is
1000 a mistake or is it ok to set it at such high number. I assume
parallelism during gather stats operations depend on JQP.

CP.

Other related posts: