Re: aq_tm_process & job_queue_process

Satheesh Babu S wrote:
> Hi, i have advised one of our client to put zero for both these
> parameters in a test instance. Since it is a test instance it doesn't
> ran any queue or jobs.
> But the customer claims that after changing these 2 parameters they are
> having serious performance issues. He also claims that once he put
> these old value back, system is working fine.
> I can't think of any reason that making zero to these parameters will
> affect the performance.
> He is running in 9205 in tru64.
>
> Thanks and Regards,
> Satheesh Babu.S

You gave some bad advice.

SELECT owner, name, enqueue_enabled, user_comment FROM dba_queues;

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)