job_queue_processes in 11g
From: C P <carlospena999_at_gmail.com>
Date: Thu, 29 May 2014 14:35:12 -0500
Message-ID: <CAPTPB13CHpkYtezLzXLEDW5KtkHwvuF4=w4Lipvw5xk39NA2Cw_at_mail.gmail.com>
List
Date: Thu, 29 May 2014 14:35:12 -0500
Message-ID: <CAPTPB13CHpkYtezLzXLEDW5KtkHwvuF4=w4Lipvw5xk39NA2Cw_at_mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 29 2014 - 21:35:12 CEST