Oracle Server - aq_tm_process & job_queue

Author

aq_tm_process & job_queue_process

Satheesh Babu S

2005-05-27, 7:23 am

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

DA Morgan

2005-05-27, 9:23 am

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@x.washington.edu
(replace x with u to respond)

Satheesh Babu S

2005-05-30, 3:23 am

Can you please explain me in detail. As i mentioned we are in TEST
instance, we absolutely don't ran any queues and jobs. In what way
these parameters will cause performance degradation?
Setting aq_tm_process is going to disable the time monitoring on queue
messages and job_queue_process to zero is going to disable the
execution of job.
Sorry i am not getting the relation between these parameters and the
performance degradation. We do have few test instance where these
parameters set to zero and it is working fine.
What is exceptional in my client db?

Thanks and Regards,
Satheesh Babu.S

Connor McDonald

2005-05-30, 9:23 am

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

sounds a dubious link to me... are you sure you are not using a job to
(say) gather optimizer statistics...

Ask for a definitive test case where the customer can do:

a) run process fast
b) disable aq/job parms
c) run process slow

--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@yaho
o.com

"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------

Satheesh Babu S

2005-05-30, 11:23 am

NO, no jobs or queue.
My client claims everything is slow after setting these values, he even
says import is taking time. But i strongly feel he is messing around
with something else there. He has gone ahead with the older values and
happy. There is no harm if the values are set to non-zero values from
the application point of view. So i don't want to disturb his
happiness.
I just want to know expert comments on the relation between these
parameter and performance if any.

Thanks and Regards,
Satheesh Babu.S

DA Morgan

2005-05-30, 11:23 am

Satheesh Babu S wrote:
> NO, no jobs or queue.

How are you making this determination? Post the query.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Sponsored Links